Update dataset/report/dashboard automatically (pro...

tejakpa · ‎10-12-2016

I am not sure if my question is on the lines of this: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8521726-allow-schema-refresh-for-...

I have a dashboard that is source of a content pack and the source of the data is a SQL Azure database(directquery). My requirement is that the dashboard/report or atleast the dataset needs to be updated automatically (programatically) to include data from new tables when they are created in the same or even a new database. Is there an API or some way that will allow me to trigger this automatically when a new table/database is created(in the same server with same auth settings)? The idea is to push updates to the content pack subscribers as and when the database is updated. Thank you

v-chuncz-msft · ‎10-16-2016

@tejakpa,

Here lists all Power BI REST API operations. Based on my research, you may need to manually republish and refresh your data in your scenario.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tejakpa · ‎10-12-2016

I am not sure if my question is on the lines of this: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8521726-allow-schema-refresh-for-...

I have a dashboard that is source of a content pack and the source of the data is a SQL Azure database(directquery). My requirement is that the dashboard/report or atleast the dataset needs to be updated automatically (programatically) to include data from new tables when they are created in the same or even a new database. Is there an API or some way that will allow me to trigger this automatically when a new table/database is created(in the same server with same auth settings)? The idea is to push updates to the content pack subscribers as and when the database is updated. Thank you