Direct Query is a data connectivity mode allows you to Direct Connection with live data base. It does not load or copied data into Power BI model, because data directly came from data source.
When you click or interact with any visualization, due to direct connection mode queries are directly hit to database and you got the updated data into visualization. So there is no need of refresh the data.
Refer – Import Mode Vs Direct Query Mode Difference
Let’s get started-
Follow these steps in order to get data from SQL server to Power BI using Direct Query Mode-
Step-1: Go to Home tab> click on Get Data tab > Select SQL Server.
Get Data from SQL in Power BI
Step-2: After that one pop-up screen will appears, enter you SQL Server name with database & select Data connectivity mode as Direct Query and click on OK button.
Direct Query Connectivity Mode
Step-3: After Load data it will appears under Fields Pane, here you can rename the dataset, just right click on data set and rename it.
How will you identify connection is Direct Mode or not?
You just hover the mouse on Data set name, it will show you Mode name as a Tool Tip. Also you can see storage mode name right hand bottom side.
Direct Query Mode – Check Data Storage Mode
Direct Query not support Data Tab, because it does not store data in Power BI cache or model. So Data Tab is not visible here.
Direct Query no data tab
Import mode support Data tab, because it stores data in Power BI cache.
Import Mode Data tab
Is it any way to see Data in Direct Query Mode?
Yes, you can see preview of loaded data help of Transform data, Go to Home tab, then Click on Transform data.
Transform Data
You can see in below screen shot-
Direct Query Mode – View Data
Similar Post
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended Post:
How to create Custom Theme in Power BI
nice explanation
,,,,awsome sir
Thanks Sathish