06-17-2020 09:13 AM
Hello everyone,
In this video we 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
--------------------------------------------------------------------------------
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
watch?v=NTUfX9HNdK0