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

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

tejakpa — Thu, 13 Oct 2016 03:22:57 GMT

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-sql-azure-direct-connect

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

Need to update dataset/report/dashboard programatically when database is updated with new tables

tejakpa — Thu, 13 Oct 2016 03:18:56 GMT

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-sql-azure-direct-connect

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

v-chuncz-msft — Mon, 17 Oct 2016 05:20:40 GMT

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