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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 205 members 1,963 guests
Please welcome our newest community members: