Forum Discussion
Cannot refresh dataset for Azure SQL Server
If you're really stuck, copy one of your queries in a dataflow to see if it refreshes successfully, and if it does, migrate the rest of your queries to dataflows then source your dataset from them.
You mentioned you update your dataset , how did you update ? After you updating your dataset , did you update your gateway in Manage gateways ? Can you refresh normally in Desktop ?
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am able to update the dataset in Desktop and in the web app -- but as shown in my screenshot, I cannot *schedule* a refresh. I do not have a gateway installed as this is an Azure managed instance that, as far as I understand, does not require one (and never did before). As I mentioned, this worked just fine for months.
I have used otravers' suggestion of using a dataflow instead of refreshing the data set. I did that and set up a refresh schedule; it works perfectly. However, the dataset that is based on the dataflow still has exactly the same error (no option to refresh it, exactly as shown in the screenshot I posted initially).
So . . . now I have a dataflow that updates, but still no way to update my dataset.
Any further help would be appreciated!