Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
manvishah17
Responsive Resident
Responsive Resident

Which data source is preferable when my data is coming from CRM ?

We currently have data in our CRM system.

We need to bring this data into Power BI, either by retrieving it through the OData Source API or the Dataverse API, where the necessary joins are performed. Alternatively, the transformations can be carried out directly within Power Query.

We are working with multiple tables and a large dataset so which method is optimized one ?

 

4 REPLIES 4
Omid_Motamedise
Super User
Super User

The optimal approach depends on the size of your data and the complexity of the joining and transformation process. While it is influenced by your data structure, I prefer using Power Query because it offers flexibility, making it easier to handle future changes in the data structure.

If my answer helped solve your issue, please consider marking it as the accepted solution. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query#limitations 

manvishah17_0-1728910856352.png

As per this link , we can see that dataverse time limit is 5 minutes and its fixed , so what to do if timeout error happen ? Is there any fix available for this ?



Anonymous
Not applicable

EVERYTHING is easier when you use Power Query.

 

--Nate

ToddChitt
Super User
Super User

What is driving your preference? Is it by ease of use, or by pure performance? While certainly not an expert on these two approaches, with both being API's, I bet the performance difference would be negligible. If you have to, develope a small test using both methods, same source table, same filters and number of rows returned, and time the results.

What method does your team prefer? What are they most comfortable with?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors