Help needed: Ways to Connect with Dynamics 365

[GuidoPinares]

Hi Community,

I am working on a Report that needs just two Rows of the table contacs in Dynamics CRM and 3 rows of other table also inside Dynamics CRM or Dataverse. I tried two different options.

1st Option. Bring it through Web.Content using API and Relative Path to filter correctly in Power BI Service. This works awesome, but I realice that only brings 5000 rows, this doesnt work for me because i have more than 100,000 rows.

2nd Option. Bring it through OData feed. In this case, it works with the filters but only in Power Bi Desktop, but when i published it to the server, it shows the error related to Dynamic Content, this error can't be solved in the same way as in Web.content so i think this is not the best option neither.

Is there another way to bring the data, but only what you need, instead of bring all and then filter, delete rows and so on? Some type of connection or code that can use to bring you the data that i want no use not all 60 columns.

Thanks in advance

[johncolley]

Hi @GuidoPinares , I would recommend using the Dataverse connector. You'll still need to perform the data transformation steps in Power Query to remove columns, rows etc, but it is a striaghtforward approach.

[GuidoPinares]

Thanks for the answer, but if the data is more than 80mb that connect wont be useful

[johncolley]

Are you able to utilise the Data Export Serivce?

[GuidoPinares]

Yes, but it brings all the table with all the data from years and years, i would like to filter it before it comes, not after with power query.

[johncolley · Accepted solution]

Only include the 2 tables you require in your Data Export Service Profile, then transform the data in the SQL Database before pulling it into Power BI.