Forum Discussion

Mike's avatar
Mike
New Member
11 years ago

New Tables from Azure SQL DB not Updating

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 Az...
mhenning's avatar
mhenning
Advocate I
11 years ago

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's avatar
    dark494
    New Member
    11 years ago

    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's avatar
      Solutionz
      Helper I
      11 years ago

      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?