CDS TDS Endpoint and Power BI Automatic Page Refresh

[Mike282]

Hi all,

So I know Dynamics 365/Common Data Service releasted a TDS endpoint which will allow me to connect Dynamics entities via direct query for near real time data.

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query

My question is in regards to another function of Power BI which is the Automatic Page Refresh (APR) function.

The other question is in regards to the fact that it needs a premium capacity workspace or embedded report. Will this work with the new Premium per user license? Say if I want to display a dashboard on a TV with APR constantly updating stats will 1-2 premium per user licenses be enough? One to author the report and the other to authenticate and pull the report onto a shared TV dashboard?

[v-cazheng-msft]

Hi @Mike282 

Power Per User supports automatic page refresh, you can refer the picture under General questions 6 in Power BI Premium Per User FAQ(preview).

Premium Per User license will have all the capabilities of Pro license and part capabilities of Premium license. With Premium Per User, users can creates report and dashboards. However, if the reports are saved in the  workspaces that are deployed in Premium capacity got by Premium Per User license, the content can only be  accessed by other Premium Per Users.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.