Update dataset/report/dashboard automatically (programatically) when database is updated

[tejakpa]

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]

@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.

[tejakpa]

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