Skip to main content

Power BI

Under Review

Connection to Common Data Service (CDS)

Vote (69) Share
's profile image

on 03 Nov 2016 15:02:49

Please create a data connection to CDS as a data source. This is the database model behind PowerApps

Administrator on 11 Feb 2017 03:16:58

Thanks for your interest in this connector! With this update of the Power BI Desktop, there is now a preview of the PowerApps Common Data Service connector. You can read more about the preview here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-feature-summary/#cds Once the Common Data Service team expands the number of people with access to the connector to everyone, we will remove the "beta" tag and close the suggestion as completed.

Comments (8)
's profile image Profile Picture

Maheed on 05 Jul 2020 23:20:26

RE: Connection to Common Data Service (CDS)

Tried using CDS for Apps with Dynamics 365 environment. I found it very useful. But i see 2 areas that need to be improved/fixed.

1- Retrieving the Entity Field Labels rather than the field internal names will be highly
useful, specifically for custom entities and custom fields.

2- The option "Add Display Column = TRUE" is not working with Multi-Select Option sets

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:40

RE: Connection to Common Data Service (CDS)

Please confirm that Power BI will be able to combine CDS data with other data sources!! We built our pipeline to depend on CDS, but now we can't bring other data sources and can't edit the queries... that is killing us!!!

's profile image Profile Picture

Alex Ramalho on 05 Jul 2020 23:03:02

RE: Connection to Common Data Service (CDS)

Much time have passed and what are the news? Nothing at all??

's profile image Profile Picture

Meagan on 05 Jul 2020 22:53:27

RE: Connection to Common Data Service (CDS)

I was quite disappointed to find that this connector creates a live connection with no option for imported data. This means that I cannot combine it with other data sources in the same report. Are there future plans for offering a non-live connection to CDS?
Using Power Apps by itself is nice, but I don't see that many use cases where I want to report on Power Apps data alone. I can see lots of cases where I want to capture some data using Power Apps and then combine it with other sources in Power BI. That makes this connection to CDS essentially useless for me.

's profile image Profile Picture

Victoria SD on 05 Jul 2020 22:53:10

RE: Connection to Common Data Service (CDS)

It must be possible to connect to my own entities... I think it's annoying that you are forcing us to use their Entities.

's profile image Profile Picture

Daniel Bartley on 05 Jul 2020 22:48:38

RE: Connection to Common Data Service (CDS)

CDS looks interesting as Master Data Services reimagined for PaaS delivery.
Power BI, Power Apps and Flow need to work together seamlessly for this approach to work.

Maybe I'm missing something. Are we supposed to export out the data to another service?

's profile image Profile Picture

Venkat on 05 Jul 2020 22:47:22

RE: Connection to Common Data Service (CDS)

How to enable powerBI integration with powerapps.Active button is not highlighted in my poweApp admin center

's profile image Profile Picture

Edward Gray on 05 Jul 2020 22:45:08

RE: Connection to Common Data Service (CDS)

I need to be able to access Custom Entities that I created within CDS. How would I do that? How can I create new perspectives inside CDS to utilize within Power BI?