dataset refresh from SPO List

[OneWithQuestion]

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!

[v-ljerr-msft · Accepted solution]

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]

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

[sbsinno]

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