Forum Discussion

bimotor's avatar
bimotor
Frequent Visitor
1 year ago
Solved

Semantic Model Won't Refresh: Token Expired On Dataflow (Gen1)

Hi,   I have a dataflow Gen1 with two different excel data sets within it, both of these are drawing information from SharePoint.   The dataflow refreshes fine on-demand, and on the scheduled ref...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.