Power Apps Visual for Power BI - CDS Direct Query Mode

In this video Power Platform MVP, Reza Dorrani will use the Power Apps visual in Power BI to add/update data in CDS using Direct Query Mode.

The Power App will refresh the Power BI report instantaneously and provide a virtually unlimited refresh scenario.

The Power BI report is using CDS with direct query mode to not rely on scheduled refreshes or imports.

SharePoint Import Mode is also covered as part of this video.

Setup CDS for Direct Query

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/view-entity-data-power-bi

 

Direct Query Vs Import Vs Live Connection

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

https://www.youtube.com/watch?v=y4S-k34qmnw

https://radacad.com/directquery-live-connection-or-import-data-tough-decision

 

List of data sources and their supported refresh types

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

 

--------------------------------------------------------------------------------
About the Author: 
Reza Dorrani, MVP
YouTube
Twitter

 

 

watch?v=NTUfX9HNdK0