Power BI embed into web page and automatic refresh

[Chapin4u]

Hello,

We have a project that we need to embed several dashboards into our web page. All embedded reports need to refresh on a daily basis. Our viewers won't be allowed to view the source tables. Our web runs under Joomla, all data sets are stored in Azure SQL. We used Power BI desktop to create our dashboards. My questions

1. Which option do we use, import direct query
2. How do we embed the dashboards without the tables
3. How do we automatically refresh the dashboards on a daily basis

Thanks in advance for any help received.

John

[jocaplan-MSFT]

If you use direct query, the data will always be up to date. No need to refresh. Users do not need direct access to the underlying tables. What does it mean to embed without tables?

[kobaldm]

mmh. I guess i must correct you. I also use DirectQuery. Neither in PowerBi Desktop(except changing a measure) or in the Azure Cloud. There is no automatic update !

From my understanding you need to trigger dataset.setAllConnections method in the node SDK. This is not working right now for me. See

http://community.powerbi.com/t5/Developer/datasets-setAllConnections-not-working-in-Node-SDK-and-CLI...

michael