Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jmillsjmills
Helper III
Helper III

Salvaging a Dense, Slow Power BI Report

Hello,

 

I've made a Power BI document containing c200 different data sources which are all different websites. As I kept adding each additional website, the document gradually got slower and slower. Is there a limit? My PC gets exhausted running the report, even though I unchecked "Load to Report" on all queries except the aggregate query which appends all the tables anyway.

 

I eventually started another document as I still need to add a few more hundred sites, querying the other websites as probably 100 at a time so these run better.

 

Although the 200 site report ran ok before (but slowly), it's now asking me to "Connect" the credentials again. where you specify anonymous access in that dialog box etc. Issue is there are 200+ websites and connecting even just 1 website takes 15 minutes because it runs so slowly and it wants me to connect all 200 again.

 

So a few queries:

- how can I structure this better?

- is there some way I can quickly pull out the advanced editor code for all 200 queries and split these across new documents without having to rewrite all 200 queries

- is there a way I can reconnect the credentials as anonymous by default without having to do each query one by one and wait 15 minutes each time

 

thank you so much in advance! Any help is so welcome because I really am struggling, but don't want to lose the work I've done

 

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @jmillsjmills ,

I'd like to suggest you refer to the document  about optimizations guide for Power BI.

 

Best Regards

Lucien

aj1973
Community Champion
Community Champion

Hi @jmillsjmills 

Adding soucre that much will soon or later going to slow your report. Don't forget you ony have 1GB of Dataset size if you are on Pro license. A little help here; in Power Query 

aj1973_0-1643332181892.png

right click on your tables to disable the load of the sites or tables that you want not to be loaded.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.