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.
Solved! Go to Solution.
Hi @Tahreem24
SQL server as you can push the native query back to the server and use its resources.
When considering Excel then the location of the files ( SharePoint folder, data lake or local drive ) will have an impact on the performance.
Probably SQL will be faster most times and will give you an ability to Direct Query on larger data sources.
Hi @Tahreem24 ,
Hopes the following links can produce some help:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Tahreem24 ,
Hopes the following links can produce some help:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot @v-yingjl and @Mariusz for sharing the insigthful links and details respectively!
That's my pleasure😀.
Regards,
Yingjie Li
Hi @Tahreem24
SQL server as you can push the native query back to the server and use its resources.
When considering Excel then the location of the files ( SharePoint folder, data lake or local drive ) will have an impact on the performance.
Probably SQL will be faster most times and will give you an ability to Direct Query on larger data sources.
Hi @Mariusz,
thanks for your response. I am just getting startet with Power BI and hope that you can maybe help me a little bit on that topic. I still didn't fully understand the advantage of a SQL Database. We are planning to connect multiple EXCEL spreadsheets to create a big Power BI Report/Dashboard. Setting up a SQL Database will prolong our project for another two months. However, some of my colleagues are worrying about the performance of the system and want to setup that SQL-Database.
My idea is to build a data flow, which connects all the different sharepoint spreadsheets. As far as I understand, the spreadsheet data is then stored in an Azure Data Lake. As long as I just update the spreadsheets once a day or every few days, the data lake should provide a highly reliable and perfomant data source. Or am I getting something wrong here?
Best regards
NLZ
@Mariusz ,
Thanks for your reply.
Yeah I know SQL is faster that Excel. But do you have some links because I need to create POC so require some links or reference for this.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |