This issue with PowerBI connectivity is now ONE YEAR OLD, as of next week.
Milinda Vitharana, Principal Program Manager, Tuesday, February 7, 2017 Today we are pleased to announce the availability of Power Apps Common Data Service (CDS) connector to Power BI desktop as a preview. You can now create rich reports with the data in CDS using Power BI desktop, the authoring tool for Power BI. Using the full power of Power BI, you can then go on to create and share stunning dashboards with users in your organization.
Many of us in the forum have expressed interest in the capability, but unable to activate.
It is understandable to have a lag between announcement -> limited preview -> controlled rollout -> fully supported feature.
However it is NOT understandable that no further announcements have been made, nor have there been any comments or resolutions offered by Microsoft. Additionally, there was a link posted to request early access, but that email address no longer works.
I have a suspicion that (1) the connector is completely unreliable at this time; or (2) it will not be offered; or (3) CDS = B.S. and there is no market acceptance.
Yeah this is a pain. We are getting charged for Power BI and Power Apps (and CDS). Does anyone from Microsoft in the know reply to these threads or are we doomed to being mushrooms (kept in the dark)?
My experience in the PowerApps forums has been very different, they are very quick to respond with useful information.
However, the Power BI connection is out of their hands. I am surprised at how long Microsoft (or designated forum admins) has left this thread adrift with a whole lot of "nothing". One. Full. Year. Since the announcement.
Sure these things take time, but then why not correct the original, and now invalid preview announcement?
No news, and not even the courtesy of a reply from anyone from Microsoft who might be monitoring this forum.
I have recommended to my client we cancel the pilot project, in favor of either a pure Azure SQL DB solution, or simply go with a responsive vendor such as OutSystems, who offers a similar type of data service, albeit a bit more complicated and pricey. But "cheap" don't make it if you cannot connect to the data, eh?
Still no availability and it's a year later since they said "they are proud to announce availability". The latest Power BI update also has Common Data Service for Apps as a beta connector but zero information on how to use it. Any and all server URL's I tried end up saying the address does not point to a database.
The standard Common Data Service connector has gone back to the "Not available in your Region" (USA) message.
This is getting very frustrating because it's been a year since they announced it first and we have multiple CDS datasets behind Apps that we are currently in parallel maintaining in a seperate DB since we can't just use that data in Power BI.
I successfully managed to connect to that Service Yesterday and, it did exposes all the entities within the CDS Model. In the Server URL, I used the dynamic.crm URL.
edit: I should note we're not running Dynamics 365 yet so I'm unclear what the dynamics.crm would be if I just have a Entity in a CDS and an App running on top of it.
How? As in where do you get the Server Url? When I try something like https://web.powerapps.com/environments/_____________/entities (with the _____ being the identifier) I get the following view:
"OData: The given URL neither points to an OData service or a feed:". Do I use the actual App url which also didn't work?
Note I'm trying to use the "Common Data Service for Apps (Beta)" connector since the "Common Data Service (Beta)" is giving me the not availabe in region message.
On that front I do not have a "Enable" button that some other were seeing a year 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.
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.