Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.