OLE DB or ODBC Error when refreshing Dataset

[Anonymous]

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]

@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]

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

[Anonymous]

@parry2k The data source is a PowerBI.Dataflows and im using Power BI Desktop

[parry2k]

@Anonymous 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?

[V-pazhen-msft]

@parry2k 

This kind of issue is difficult to troubleshoot as I could reproduce your issue. However regarding to expired token, it can be updated through the SetAccessToken feature.

For how to get an Access token, please follow:

1. Retrieve an access token

2. How To: Get embed token using Get/Post only

If not solved, I recommend you scroll down and create a support ticket in Power BI Support to get further help.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.