Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
9 years ago
Solved

dataset refresh from SPO List

I have a dataset that uses a SharePoint Online list.

 

It works great in desktop.

 

Then I deploy to service, and go to the settings for the datasource and do OAuth for security, then it seems to accept that.

 

However, when I click the REFRESH icon, it does not update the last refreshed date.

 

Am I missing something obvious?  Thanks!

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi OneWithQuestion,

    However, when I click the REFRESH icon, it does not update the last refreshed date.

    Do you mean the "Refresh" icon on top of a report page like below? Clicking that "Refresh" icon won't refresh the dataset of the report, it will just refresh all tiles on the current report on your browser.

     

     

    To refresh your dataset on Power BI service, you need to click "Refresh Now" or configure a schedule refresh under Datasets > ACTIONS like below.

     

     

    Regards

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi OneWithQuestion,

    However, when I click the REFRESH icon, it does not update the last refreshed date.

    Do you mean the "Refresh" icon on top of a report page like below? Clicking that "Refresh" icon won't refresh the dataset of the report, it will just refresh all tiles on the current report on your browser.

     

     

    To refresh your dataset on Power BI service, you need to click "Refresh Now" or configure a schedule refresh under Datasets > ACTIONS like below.

     

     

    Regards

    • sbsinno's avatar
      sbsinno
      New Member
      9 years ago

      this is what i did and i get error after error anyway. the latest is:

       

      Last refresh failed: Wed Jun 07 2017 23:17:53 GMT+0800 (Malay Peninsula Standard Time)
      Cannot connect to the mashup data source. See error details for more information

      Underlying error code:-2147467259
      Underlying error message:The column 'Client_Title' of the table wasn't found.
      DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
      Microsoft.Data.Mashup.ValueError.Reason:Expression.Error
      Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
      Activity ID:82c68305-e10a-45e7-b344-35572c586e3e
      Request ID:3b3038db-31d8-614e-4b53-9db915f2d1ad
      Time:2017-06-07 15:17:53Z

       

    • sbsinno's avatar
      sbsinno
      New Member
      9 years ago

      the solution is what i do but i stil get error after error.

      after i fixed one this one came next

      Last refresh failed: Wed Jun 07 2017 23:17:53 GMT+0800 (Malay Peninsula Standard Time)
      Cannot connect to the mashup data source. See error details for more information.Hide details
      Underlying error code: -2147467259
      Underlying error message: The column 'Client_Title' of the table wasn't found.
      DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
      Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
      Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
      Activity ID: 82c68305-e10a-45e7-b344-35572c586e3e
      Request ID: 3b3038db-31d8-614e-4b53-9db915f2d1ad
      Time: 2017-06-07 15:17:53Z