cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
juanito Frequent Visitor
Frequent Visitor

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

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.

4 REPLIES 4
v-haibl-msft Super Contributor
Super Contributor

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

@juanito

 

Currently there is no other connector without using OData Feed.

 

Best Regards,
Herbert

tringuyenminh92 New Contributor
New Contributor

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

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 Frequent Visitor
Frequent Visitor

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

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 New Contributor
New Contributor

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

Hi @juanito,

 

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