The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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
I believe it is showing the number of rows, not the amount of data.
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?
That may be correct, I was using a Web connection to test the data refresh, might be different for CRM. I'll check.