cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

Why forcing Power BI to only load CDS data via perspectives and not entities?

I'm trying to load entities in PBI and sadly I can only load via perspectives.  Even more sad, is the fact that only 2 custom entities are allowed 😞

 

Does anyone been able to load entities directly in Power BI from CDS?

 

Thanks,

 

Ben

3 REPLIES 3
Highlighted
Power Apps
Power Apps

Re: Why forcing Power BI to only load CDS data via perspectives and not entities?

Hi Ben,

 

Thanks for your feedback - this is a known limitation in the preview of the CDS PowerBI functionality and we have work planned to allow direct access to entities. At this point I don't have a confirmed timeline, but if you post an Idea on the idea forums we can keep track of it there.

 

Regarding only being able to use two custom entities - could you please provide more details - do you receive an error? If you can give details on what you're trying to do and what is stopping you, I can discuss this with our team.

 

 

Thanks,
Clay.
Highlighted
Kudo Collector
Kudo Collector

Re: Why forcing Power BI to only load CDS data via perspectives and not entities?

Thanks Clay.

 

Yes, sadly, I get an error telling me only 2 custom perspectives are allowed 😞  See the message I get.

Is there any workaround I can use to finish my project?  This prevents me from using CDS accross numerous use cases since I have to expose the CDS real time data into Power BI.

 

Thanks...

 

Capture.JPG

 

Highlighted
Power Apps
Power Apps

Re: Why forcing Power BI to only load CDS data via perspectives and not entities?

Thanks for sending through the screen shot, while I wasnt aware I've confirmed this limitation exists. At this point unless your data model is compact enough to be presented in two perspectives (if the entities are all related).

 

The other option is to join the update preview program, which would have other options for you to build this type of report : cdspreviewprogs (at) microsoft.com.

 

Thanks,
Clay.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,191)