Forum Discussion
Online Service Functionality in Power BI
- 9 years ago
Hi Budfudder,
How can I get the same sort of functionality from the desktop client? Is it possible?
You can connect to CRM with Power BI Desktop, however, you may need to rebuild the whole reports yourselves. Or you can make use of CRM solution template. There seems no easy way to do it currently.:smileyhappy:
Do I have to tell you that this is an absolutely ridiculous restriction? It means that Power BI Online is simply unusable by my company as we have more than 100,000 records on several tables.
In addition, I would suggest you to submit your requirements on Power BI Ideas and vote it up to improve the functionality of CRM content pack.
Regards
A bit of further information - the inability of the CRM content pack to import more than 100,000 rows is documented. From https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-crm/:
From System Requirements:
- An account with less than 100k records in any of the tables. Note if the account has access to more than 100k records the import will fail.
Do I have to tell you that this is an absolutely ridiculous restriction? It means that Power BI Online is simply unusable by my company as we have more than 100,000 records on several tables.
Hi Budfudder,
How can I get the same sort of functionality from the desktop client? Is it possible?
You can connect to CRM with Power BI Desktop, however, you may need to rebuild the whole reports yourselves. Or you can make use of CRM solution template. There seems no easy way to do it currently.:smileyhappy:
Do I have to tell you that this is an absolutely ridiculous restriction? It means that Power BI Online is simply unusable by my company as we have more than 100,000 records on several tables.
In addition, I would suggest you to submit your requirements on Power BI Ideas and vote it up to improve the functionality of CRM content pack.
Regards