Forum Discussion

petersi's avatar
petersi
Icon for Helper II rankHelper II
9 years ago

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 on...
Need Help
petersi's avatar
petersi
Icon for Helper II rankHelper II
9 years ago

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.

shill1000's avatar
shill1000
Icon for Helper IV rankHelper IV
9 years ago

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.

  • petersi's avatar
    petersi
    Icon for Helper II rankHelper II
    9 years ago

    As I mentioned -- I saw this already - and it is set.

    • shill1000's avatar
      shill1000
      Icon for Helper IV rankHelper IV
      9 years ago

      Is it set the same for all datasets? You indicated you use multiple sets.

      • petersi's avatar
        petersi
        Icon for Helper II rankHelper II
        9 years ago

        per Power BI documentation -- all datasets defined within a report are combined into one dataset on Power BI. So I have only one Dataset on Power BI. All are configured with the same infomration - and credentials. I can manually update the Datasets within the report via the manual update. No credentials are requested so it looks like the credentials are available. I see now errors on Power BI when an scheduled update is performed.