Using a single datasource for multiple web queries

[wilson_smyth]

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?

[Anonymous]

@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

[wilson_smyth]

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.

• https://myCRMInstance.dynamics.com/api/data/v8.2/appointments()?$select=subject, activitytypecode,_regardingobjectid_value,scheduledstart
• https://myCRMInstance.dynamics.com/api/data/v8.2/activityparties?$select=*&$expand=activityid_appointment($select=*)
• https://myCRMInstance.dynamics.com/api/data/v8.2/systemusers()?$select=systemuserid,fullname

Note: URL's are not 

[Anonymous]

@wilson_smyth,

What result would you like to show for these connections in Power BI Desktop?

Regards,
Lydia

[wilson_smyth]

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.