Forum Discussion

Mohammadshareef's avatar
Mohammadshareef
Frequent Visitor
9 years ago

Can't connect to Power Apps Common Data Service??

Hi PowerBI Team I have built a Power App that stores data in the Common Data Service. We captured a bunch of data in the app. I went to connect to the Common Data Service in Power BI Desktop (yes, I...
General Comment
tommy_g's avatar
tommy_g
Icon for Helper V rankHelper V
8 years ago

I suspect they made significant changes to the product / service, and then abandoned the early 2017 promise. With the recent big splash on the new, expanded CDM with two distinct CDS channels (one for apps, one for analytics) that we are just going to have to wait until the Analytics branch becomes available. Based on the latest updates, it looks like Q3 2018 as the earliest.

 

I my case this is a moot issue, while CDM is an appealing simplification of data access and integration, it's reallly most useful in the context of D365. We have already made strategic product plans to use plain-old SQL, in this case Azure SQL DB + Azure Analysis Services. At scale, this is far more flexible and economical than what CDM provides.

 

Overall, the Power BI team has done so many wonders at such a rapid cadence, with almost NO regresssions, I have no complaint. Nobody's perfect.

skmcken's avatar
skmcken
Frequent Visitor
8 years ago

The 'Common Data Service for Apps Connection' links to the Dynamics Instance If you are using CDS 2 and Model Apps. That does not mean that you have Dynmics 365 Deployed.

 

I believe the 'Common Data Service' connection only now links to your default Instance of CDS which in my case has not been updated to CDS 2.

 

Any of my new Environments using CDS 2 can be linked to using the Apps Connection Model. 

  • sxt173's avatar
    sxt173
    Icon for Advocate II rankAdvocate II
    8 years ago

    Solved: (I'm not certain this is the same across all deployments) the Server Url is https://xxxxxxxxx.crm.dynamics.com/ where the "xxx" is the unique Environment ID that you are given in a CDS v2 environment.

     

    Thanks for the info. I spent (what seemed way too long) to transfer my entities and apps to a new CDS v2 environment. It seems the import/export is not fully functional but that is to be expected.

     

    So I'm still lost as to what Url I input in Power BI when on this screen. The App URL does not give me anything so is there a server address that I'm totally missing?