Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!