Using Direct Query with MS Azure SQL - New Data Source Support

preview_player
Показать описание
Direct Query is a new capability in Qlik Sense SaaS that enables analytics apps to generate SQL queries directly against cloud databases as the user interacts with data through visualizations and dynamic filtering.

Resources:

Qlik Community:
  1. Qlik
  2. SQL
  3. MS
  4. azure
  5. direct
  6. query
Рекомендации по теме
Using Direct Query 0:06:56

Using Direct Query with MS Azure SQL - New Data Source Support

Connecting To SQL 0:07:59

Connecting To SQL Server using Import /Direct Query Mode in Power BI

Power BI DirectQuery 0:25:23

Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward

Power BI - 0:05:48

Power BI - Do it Yourself Tutorial - Import vs DirectQuery Mode - DIY -37-of-50

Microsoft Power BI 0:02:38

Microsoft Power BI | How to get data from SQL server? | Tutorialspoint

Decoding Direct Lake: 0:05:17

Decoding Direct Lake: The Truth Behind DirectQuery Fallback

Direct Query Vs 0:10:03

Direct Query Vs Import Method in Microsoft Power BI A Practical Demonstration

Connecting To Direct 0:12:20

Connecting To Direct Query Mode in Power BI Desktop || Real time Scenario

Introduction of DBMS 1:01:59

Introduction of DBMS SQL Queries and Data visualization including PostgreSQL and POSTGIS

Import vs DirectQuery 0:04:27

Import vs DirectQuery Storage Mode?

Direct Lake and 0:48:04

Direct Lake and Direct Query in Microsoft Fabric

PBIMCR - Direct 1:02:52

PBIMCR - Direct Query with Chris Webb

Different ways to 0:07:51

Different ways to work with Microsoft Excel in Power BI (2023)

EnLearning | Direct 0:03:45

EnLearning | Direct Query for Power BI Datasets and Azure Analysis Services

Power BI: Realtime 0:22:06

Power BI: Realtime Sales Simulation using SQL Server and Direct Query (Portfolio Project)

Microsoft Dataverse Support 0:14:47

Microsoft Dataverse Support For Power BI

Direct Lake vs 0:07:19

Direct Lake vs Direct Query vs Import mode in Power BI Desktop using Fabric SQL endpoint

Best data source 0:05:41

Best data source for DirectQuery in Power BI?

Live connection / 0:50:05

Live connection / Direct Query and Import in Power BI | Power BI tutorial

Enable QUERY FOLDING 0:04:41

Enable QUERY FOLDING for native queries in Power Query / Power BI

How to connect 0:04:46

How to connect power bi with Microsoft access database and import data

Direct Query Limitations 0:02:04

Direct Query Limitations in Power BI

DirectQuery, Power BI 0:05:46

DirectQuery, Power BI Datasets and Analysis Services 2017

How to use 1:51:37

How to use SQL with Power BI 💡 ~ End-to-end Demo with Sample Files

Комментарии
Автор

Direct Query is a new capability in Qlik Sense SaaS that enables analytics apps to generate SQL queries directly against cloud databases as the user interacts with data through visualizations and dynamic filtering.

Resources:



QlikOfficial
Автор

So what might be the reasons that "files and other sources" is not available? And I see your other answer, the 3 dots only apear at MSSQL. How would I achieve this via MySQL?

rhsxijr
Автор

I'm trying it with SQL Server database, installed the gateway and configured the connection, but when clicking on the 3 dots to open the direct query menu (3:09), the option is not there. Am I missing anything else to make it work? Thanks

beato