Showing results for 
Search instead for 
Did you mean: 
Robertangi Frequent Visitor
Frequent Visitor

Power BI and CRM

Hi everyone! At my company, we are creating a new data model and we imported it into a PBIX file but hit the file size limit of 1GB so we are going to create a SSAS Tabular cube instead and connect to it DirectQuery instead. I am assigned to a new project now where we are going to analyze e-mail data from our CRM system. What i would like to know is sort of best practises for creating this report.


I will need to model the data and transform it with Power Query and create some DAX calculations. At the moment i am connecting to CRM Online from the Power BI Desktop. When i am done with the modeling i will upload it to the PBI Service and it will be refreshed since the data is from the CRM service. My question is this.. The data in the report will become huge very fast and will i hit the file size limit if i download the data again to PBI Dekstop if i would need to modify the data? Is there a better way to create this report/dashboard?


Many thanks,


v-yulgu-msft Super Contributor
Super Contributor

Re: Power BI and CRM

Hi @Robertangi,


Per my understanding, no matter how you load data into Power BI desktop, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message.



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 28 members 882 guests
Please welcome our newest community members: