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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors