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.
I am querying CRM Online data. The standard oData connector is inefficient and limited in its functionality so I have been using the Web Api ( the "web" source under the Get Data Menu).
I am getting data from about 15 entities this way, but now I have credentials for 15 seperate data sources to manage.
Can anyone advise if it is possible to consolidate these into 1 data source to make it more manageable?
@wilson_smyth,
Do you connect to different Web URLs with different credentials in a single PBIX file? If so, there is no method to consolidate these data sources into one data source.
Is there any possibility that you can use a single Web URL to get required data?
Regards,
Lydia
The same credentials are used for all connections.
I have to get data regarding multiple entities, so obtaining all data in one web query is not an option.
All web queries connect to the same instance of CRM, but deviate after a certain point, see below for example. that shows 3 entities, but i am getting data from about 10 including a number of custom entities.
Note: URL's are not
@wilson_smyth,
What result would you like to show for these connections in Power BI Desktop?
Regards,
Lydia
not sure what the question means Lydia.
I guess, I want to be able to change the web api URL in one single place, instead of for each query, which is how it currently works.
I want this to work in PowerBI Online.
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.