Forum Discussion
Dataset Auto Update
I have put together a report in Power BI Desktop - and have uploaded it to Power BI. I am trying to determine how the AutoUpdate works. I have multiple datasets defined from within the report. The only time I can get the report data to update if I do a manual update from within Power BI Desktop. So, how does the auto update work - for a deployed report.
Note: the dataset queires are configured as an import type..
A clarification. I am not seeing the report visual update when a scheduled dataset update occurred, This is what I'm trying to understand (why it does not update the visuals - or even if the data is being updated - which I see no dataset viewer to see what the current dataset is)
10 Replies
It all depends on your data source. Have you tried scheduling an update in the report settings? If it doesn't allow you to schedule it then its likely an issue with the data source type, your license type or another factor. You haven;t provided enough information to diagnose the issue.
data source is a Azure Sql Server DB. From what I'e read this type of datasource allows for auto updating. I don't see any update options in the report settings (not sure what you are referring to). I see the auto update in Power BI - and is set to update every hour. I read Power BI sets this automatically.
Select teh work space you are using. Select Settings from the top right menu. Select Datasets from the top left menu. Select the dataset you are using for your report and the scheduling options should appear on the right. Power BI defaults to a daily refresh unless you tell it otherwise.
Hi petersi,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dalenone of the answers applied. I had to rebuild the definitions on Power BI then the Auto Update started working. It is unclear what was the problem as there was nothing different I had done when rebuilding.
