It will be really helpful to allow PowerBI to perform direct query against CDM
We are happy to release this new feature as announced at the link below:
Thank you for your continued feedback,
Thx for your suggestion. Enabling PowerBI to report on CDM is high on our priorities. I am curious about your comment on direct query. Are there specific reasons why you prefer DirectQuery as opposed to Import mode ?
Yes...because powerBI Embedded works only with Direct Query. Thanks.
I also prefer direct query as PowerBI can show up to date data as users access whereas the import mode can refresh only up to 8 times a day.
Also, CDS data should be exposed to Excel Power Query with the ability to refresh
Hi @Audrie-MSFT, thanks for all the updates this is really helpful. Any idea when the PowerBI connector will be released outside the US?
Although no dates are available to share at this time, a preview feature wIll be extended to many regions supported by PowerApps and CDS. If you like to preview this feature in your region before others, or if you would like to preview this feature, drop us a mail via CDSPowerBIPreview(at)Service.Microsoft.com
Thank you again for your feedback and patience,
Hi @Audrie-MSFT, I wrote to CDSPowerBIPreview(at)Service.Microsoft.com last week but have had no response so far.
Anyway, thanks for following up.
Dear all, this is great news for Power BI, but maybe some of us still need to analyse and visualise the data in pivot tables and print reports. For this, Excel's Power Query (aka Get & Transform) is perfect.
Please add your vote to the following idea if this relevant for you:
@Audrie-MSFT the CDSPowerBIPreview(at)Service.Microsoft.com address is bouncing has the request email been changed?