Forum Discussion

Lunkan's avatar
Lunkan
New Member
10 years ago
Solved

Dynamics CRM Online database to big

Hi.   Im a beginner with power BI, and want to connect our MS crm online to PowerBi.   Our databes in MS CRM is to big and we have reached the limit. I can conenct both to PowerBI Desktop and...
Need Help
cwayne758's avatar
cwayne758
Icon for Helper IV rankHelper IV
10 years ago

You can try to limit your query in the query editor before loading it into your data model. This is done by selecting 'edit' instead of 'load' after you've selected your data source. 

 

From there, extract year from your date field if necessary, then limit by the periods you need. 

 

Hope that helps