cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

CDS Data Source.

Hi, 

I want to chage my trial CDS data source to my production CDS Data Source but I don't have that option avaliable in Power BI, What can I do?

 

CDS.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: CDS Data Source.

Hi @vsgarciap ,

 

By my test in the latest version 2.76.5678.782 of Power BI Desktop, the option works well. You may upgrade Power BI Desktop, and try it again.

 

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.

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: CDS Data Source.

Hi @vsgarciap ,

 

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

81.png

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.

Highlighted
Helper II
Helper II

Re: CDS Data Source.

I don't have available that option, that's why my question.

Highlighted
Community Support
Community Support

Re: CDS Data Source.

Hi @vsgarciap ,

 

By my test in the latest version 2.76.5678.782 of Power BI Desktop, the option works well. You may upgrade Power BI Desktop, and try it again.

 

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.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: CDS Data Source.

Hi 

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

1. Create a new parameter --> cds_environment_connection_urlhttps://<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

Highlighted
New Member

Re: CDS Data Source.

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors