cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
IanR Helper III
Helper III

What do the numbers displayed when Power BI is refreshing mean?

During a refresh the tables that I am trying to import are listed alongside numbers listed in MB and GB. This would suggest that the numbers represent the volume of data that is being downloaded – which would make sense – except that the numbers that I am seeing are far too large. I am refreshing a Power BI model from Dynamics 365 (aka CRM Online). I can see from the Organisation Insights feature in Dynamics 365 that the smallest of the ten largest tables that we have in Dynamics 365 is just over 500 MB. When I refresh Power BI I have several tables showing numbers in GB, and none of them are listed in the top ten largest tables in Organisation Insights. Any idea what is going on?

4 REPLIES 4
Super User IV
Super User IV

Re: What do the numbers displayed when Power BI is refreshing mean?

I believe it is showing the number of rows, not the amount of data.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

IanR Helper III
Helper III

Re: What do the numbers displayed when Power BI is refreshing mean?

I don't think that is right, at least not for our CRM refresh. Our contacts table has around 100,000 records. During the refresh the ContactSet table shows over 6 GB before the refresh completes. Why would they present a record count in GB? 

Super User IV
Super User IV

Re: What do the numbers displayed when Power BI is refreshing mean?

That may be correct, I was using a Web connection to test the data refresh, might be different for CRM. I'll check.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

IanR Helper III
Helper III

Re: What do the numbers displayed when Power BI is refreshing mean?

This isn't a big issue but the forum is bugging me to flag an answer. I wonder if anybody actualluy knows the answer.

Thanks

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors