OLE DB or ODBC Error when refreshing Dataset

Question

Receiving this error on a particular table when refreshing the whole dataset:

OLE DB or EDBC error: [DataSource.Error] an error happened while reading data from the provider: 'Failed to get MWC token: {"error":{"code":"TokenExpired","message":"Access token has expired, resubmit with a new access token"}}'

The table comes from a DataFlow which refreshes on its own without any issues, also I'm able to refresh this table within the Power Query Editor as well.

Any help is appreciated, Thanks!

amitchandak · Answer

Anonymous , refer https://community.powerbi.com/t5/Developer/Having-problems-to-find-the-Power-BI-AccessToken/td-p/289186
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token

parry2k · Answer

Anonymous what is your data source? Are you using Power BI embed?

anonymous · Answer

parry2k&nbsp;The data source is a PowerBI.Dataflows and im using Power BI Desktop

parry2k · Answer

Anonymous&nbsp;this is weird, I use dataflows all the time and never had this issue. I assume you are using Power BI dataflows native connector to connect to dataflow, correct?

anonymous · Answer

parry2k&nbsp;This kind of issue is difficult to&nbsp;troubleshoot as I could reproduce your issue. However regarding to expired token, it can be updated through the SetAccessToken feature.&nbsp;For how to get an Access token, please follow:1. Retrieve an access token2. How To: Get embed token using Get/Post only&nbsp;If not solved, I recommend you scroll down and create a support ticket in&nbsp;Power BI Support to get further help.Paul Zheng _ Community Support TeamIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

OLE DB or ODBC Error when refreshing Dataset

5 Replies

Related content

Refresh dataset api

Dataset refresh error - timeout

PowerBI dataset refresh error

Data Refresh Errors

refresh error