CDS Data Source.

Hi 

there are simple step within Power Query to achive this using parameters.

1. Create a new parameter --> cds_environment_connection_url = https://<environement>.crm.dynamics.com/

2. Select the query and open "Advance Editor"

3. Use the parameter within the advanced editor to build the connection string, see below example

let

    Source = Cds.Entities(cds_environment_connection_url&"api/data/v9.1/", [ReorderColumns=null, UseFormattedValue=null]),

    entities = Source{[Group="entities"]}[Data],

    systemusers = entities{[EntitySetName="systemusers"]}[Data]

Hope this helps

Urs

Hi Anonymous ,

You can change the data source via clicking "Change Source" option.

You can also refer to the link: Connect to the Power BI Using Common Data Service (CDS).

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi All,

We are encountering the similar issue The Change data source button is disabled in case of Common Data Service connection for Power Apps.

Any help would highly be appreciated.

Thanks