Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I need some help, my report has a lot of connections to my sharepoint site and the connections to the sharepoint is not the problem, but right now I was trying to add a new connection to my sharepoint and it connected to the sharepoint but didn't open the excel data i was trying to connect. It just keep loading and loading... I need to keep adding tables to the report (Its is a very heavy report), I created a new power bi report and tried the same connection and it worked fine and fast.
Can someone help me solve this problem?
Route:
Here is a picture of the power bi trying to open the excel:
It just keeps loading, Can someone help me?
Hi @carcmena99 ,
Incredibly difficult to give an exact answer on this, but my general recommendation would be to bring all these different SharePoint files/folders into Dataflows overnight and run your report from the Dataflows instead.
SharePoint is not a data warehouse and Microsoft are very open about throttling data-pull traffic in order to maintain system stability for 'regular' users. If your huge report is trying to background-refresh a lot of large queries from many SharePoint files during the working day, there's a good chance that you're getting throttled and your data is coming through at an absolute trickle.
Pete
Proud to be a Datanaut!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
58 | |
53 | |
26 | |
16 | |
10 |