Forum Discussion
Semantic Model Won't Refresh: Token Expired On Dataflow (Gen1)
Hi bimotor,
Thanks for reaching out to the Microsoft fabric community forum.It looks like you're experiencing an issue with reports that didn't refreshed in the Power Bi Service and returns a "Token Expired" error even though it is refreshing fine with both on-demand and on a scheduled refresh. You also mentioned that the dataflow and report are set up correctly but still there seems to be an authentication issue preventing the report in the service. It seems the core of the problem comes from the use of authentication tokens that is used for data sources like SharePoint and SQL Server.
These may be the possible reasons for expired token error :
* Check if the authentication token for the SharePoint is expiring.
* Also check if there is a mismatch in token authentication method.
* Check your Power Bi service refresh process as they handled differently than on-premiserefreshes.
If you're still unable to solve the issue, please raise a ticket as suggested by lbendlin.
If this post helps then please mark it as a solution, so that other members find it more quickly.
If you have any other queries, feel free to reach out to community forum for assistance.Thank you.
Hi bimotor,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you're experiencing an issue with reports that didn't refreshed in the Power Bi Service and returns a "Token Expired" error even though it is refreshing fine with both on-demand and on a scheduled refresh. You also mentioned that the dataflow and report are set up correctly but still there seems to be an authentication issue preventing the report in the service. It seems the core of the problem comes from the use of authentication tokens that is used for data sources like SharePoint and SQL Server.
These may be the possible reasons for expired token error :
* Check if the authentication token for the SharePoint is expiring.
* Also check if there is a mismatch in token authentication method.
* Check your Power Bi service refresh process as they handled differently than on-premise
refreshes.
If you're still unable to solve the issue, please raise a ticket as suggested by lbendlin.
If this post helps then please mark it as a solution, so that other members find it more quickly.
If you have any other queries, feel free to reach out to community forum for assistance.
Thank you.
Thanks for this. I should point out to any readers that my issue resolved itself, but not by following any of the above, although this may work for others. It may be unrelated, but after a Windows password change across our organisation and updating the passwords on our connections in BI, the token error cleared.