Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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
@Anonymous what is your data source? Are you using Power BI embed?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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:
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.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |