New Tables from Azure SQL DB not Updating

[Mike]

Hello,

We are connecting to an Azure SQL database which appears to work properly.  Reports can be created based on the data within the dataset without any issues.  If we add a new table to the Azure SQL database it does not show up in the existing dataset.  Removing and re-adding the dataset allows us to see the new table, but that process deletes existing reports.  Any ideas on how to have new tables appear in an existing dataset from an Azure SQL DB?

Thanks in advance,

Mike

[PBI98075]

Was this issue ever fixed?  I am experiencing the same problem and cannot find any way to bring the new table to the existing dataset.  And as stated in other posts, if I delete the dataset and recreate it, deleting the dataset also deletes the associated reports.  I dont want to have to recreate all of my reports every time that I add a new table or view to the Azure database.

[Akahn]

We also have this issue.

[mhenning]

I am having the same issue. When I attempt to refresh the dataset to pull the added tables or views I get:

You cannot schedule refresh for this dataset because it gets data from sources that currently don’t support refresh. Learn Moreabout data sources that currently support refresh.

Show details

It claims azure is sposed to be a "live" data source Reconnecting and rebuilding reports every time I add a view is just ridiculous. Surely there is a more graceful way to grab the new table,views etc. 

[dark494]

Having all the same issues. Cannot update the model without removing the dataset which would destroy all our work. What's the point of having a message on the dataset that says, "This dataset connects to a source with direct connect which is always up-to-date. You do not have to schedule a refresh on this dataset" when the model isn't ever up-to-date?

Can't refresh it either, it's not supported or something. "You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model." 

I can do it just fine in excel with power views, which is essentially the same thing here.

Is there a solution to this?

[Solutionz]

Just to add to this one, we have the same issue. It says live but is not...Then it also does not appear to have any means of refresh apart form deleting all the work.

Any advice Microsoft?

[zibited999]

We're facing the exact same problem. Anyone figure out a fix for this?

[andre]

did you try going to the Datasets section, finding your data sets, clicking on the three dots next to the name and then selecting "Refresh Now" option?

[jbocachica]

Azure DB is not a Live connection like SSAS, if you change your schema, you must re-upload your excel file or PowerBI designer file, however, keep in mind that your reports are not connected to a source name, their are connected to a sourceid, so, every time that you upload a file, even if the file has the same name, they will be create a new sourceid.

regards