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.
Hi,
In our current business setup, we have several SQL databases hosted on-site. We extract data from these databases directly into PowerBI using the SQL connection feature within PowerBI Desktop.
Although the current process is functioning effectively, we are interested in achieving more real-time updates for our reports. Currently, we use DirectQuery to achieve some real-time updates, but it has limitations as it restricts us from using PowerQuery.
We are curious whether any of the Fabric features could offer us an improvement over our current approach in terms of real-time updates and the way we store and retrieve data?
Thanks,
Solved! Go to Solution.
Hello @cc_pbi ,
yes you could have your SQL database in fabric, check this out https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
if you're also interested about various fabric topics, you could take a look at this playlist check this playlist https://www.youtube.com/playlist?list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @cc_pbi ,
well yes the microsoft fabric will give you real time data with no time and with a huge dataset.
check this out
https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Thank you, so from my understanding the lakehouse within fabric would effectively be querying the sql database with the PBI report connected to the lakehouse rather than the sql?
Do you have any experince of how much resource this eats up if there is constant communication between the sql database and the lakehouse?
Hello @cc_pbi ,
yes you could have your SQL database in fabric, check this out https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
if you're also interested about various fabric topics, you could take a look at this playlist check this playlist https://www.youtube.com/playlist?list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
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.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |