Data Set refreshes but no new data on Azure SQL Database connection

[mgrowan]

I have a report I've built in Power BI Desktop connecting to an Azure SQL Database.

At first it was connected using Data Connectivity Mode Direct Query. I published and all was good, refresh showed the new data in the database.

I then added some more things to the report and had to switch from Direct Query to Import to allow the adding of a Date dimension. Refreshing locally on Power BI Desktop works fine and I published the report.

Now however the report does not show the latest data on the service. The Data Set shows that the scheduled cache refresh is configured and the history shows it is refreshing and I can "refresh now" without error, but the new data from the database has not been included.

What am I missing?

[GilbertQ]

hi @mgrowan

Would it not be now that you have set it to Import Mode that you have to configure the refresh from the Dataset under Settings?

[mgrowan]

Thanks @GilbertQ , under settings the schedule is set to hourly and the refresh history shows it has been successful each hour, but the data is still out of date. Is there somewhere else I should be setting it?

[v-yuezhe-msft · Accepted solution]

@mgrowan,

After you change "DirectQuery” to “import” mode, please remove your dataset in Power BI Service, then re-publish your PBIX file to Power BI Service, enter credential for your data source as shown in the following similar screenshot , set schedule refresh for your dataset. Then check if refresh works.





Regards,

[mgrowan]

Perfect, thanks @v-yuezhe-msft!

After I delete the Data Set (report went too) and redeployed. I didn't need to reset credential, but set the daily scheduled refresh and all is updating.