How to upload data from CRM Online to Power BI without using OData feed?

[juanito]

Hi everyone, I would like to know if there is the possibility  to upload data to Power BI Desktop from CRM Online without using ODataFeed. Both OData feed and Dynamics 365 (Online) use OData feed.

[tringuyenminh92]

Hi @juanito,

Beside connect directly ODATA in PBI, i think you could replicate/sync data from your CRM Online to Azure SQL DB with Data Export Service in CRM Online

One more additional information, there is another in-direct approach that you extract data from CRM Online by sdk in C# and push into your on-premise database, then connect PBI to your database. but please consider the latency when you build up middle ETL step like this approach.

[juanito]

Thanks, very useful! But I would like to avoid the SQL Database or Azure and connect directly to Power BI. My main issue at the moment is related to the performance because it's very slow. This is not due to the queries but to the odata connection 

[tringuyenminh92]

Hi @juanito,

It's limitation of CRM Online, you could not access its database directly.

[v-haibl-msft]

@juanito

Currently there is no other connector without using OData Feed.

Best Regards,
Herbert