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

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.

Reply
vickyd
Helper V
Helper V

What is Power BI loading when it shows the "Loading Data" Screen?

What exactly is a Power BI Report doing when it initiallly shows "Loading Data"?

e.g I created a sample report that has nothing but a text box. No data connection, nothing. 

 

When I load that report, I get shown the "Loading data" screens for about 5-6 seconds initially. What exactly is it loading and is there a way to reduce that time? 

 

When I connect to a SSAS model, I get the same screen and then the report page where all the components start loading. So it only seems to start connecting to the DB and loading the data on the screen after it has already spent 5-6 seconds showing the "Loading data" screen.  

1 ACCEPTED SOLUTION

HI @vickyd,

I'd like to complement Greg_Deckler's point of view.

Normally, you can enter to query editor and will see your query tables with their query steps. In fact, displayed query tables records are the preview of these query formula processing results. They weren't really executed and imported source data to the query editor side.

When you click 'apply & save changes', these query steps will be executed and processing in the background and display 'loading data panel' to notice that 'power bi are busy to process your data'. (execute query steps to get data and transform data structure, then loading and convert these result tables to data model tables)

I hope the above can be helpful to your doubts.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

Pretty sure that just means it is busy.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...


@Greg_Deckler wrote:

Pretty sure that just means it is busy.



Thanks Greg.

 

I'm curious to know exactly what it is busy with though.  

In case it matters, I am referring to a report within Power BI Report Server and the test I did was on a server that is not accessed by anyone else so all of the resources as such are available. 

 

HI @vickyd,

I'd like to complement Greg_Deckler's point of view.

Normally, you can enter to query editor and will see your query tables with their query steps. In fact, displayed query tables records are the preview of these query formula processing results. They weren't really executed and imported source data to the query editor side.

When you click 'apply & save changes', these query steps will be executed and processing in the background and display 'loading data panel' to notice that 'power bi are busy to process your data'. (execute query steps to get data and transform data structure, then loading and convert these result tables to data model tables)

I hope the above can be helpful to your doubts.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors