Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am in the process of switching a operation software they have proposed using direct query from a sql database for my data needs.
This is the diagram they have supplied me with to explain how they will provide me with the data.
I have limited database knowlege, can someone explain this to me
Also if im using direct query do i need to set up my own sqldatabase or can i connect directly to the distrubution database?
Solved! Go to Solution.
This link explains the process that our data is being pushed,
Is a sql database required or can i connect direct query to the distributor?
Thanks
Do you have read access to the distribution database in the distributor? If you have, you can directly connect to the distribution database in Power BI Desktop using DirectQuery mode and create report in Power BI.
Regards,
Lydia
This link explains the process that our data is being pushed,
Is a sql database required or can i connect direct query to the distributor?
Thanks
Do you have read access to the distribution database in the distributor? If you have, you can directly connect to the distribution database in Power BI Desktop using DirectQuery mode and create report in Power BI.
Regards,
Lydia
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.