Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |