Forum Discussion
Issue: Paginated Report Loses Semantic Model Connection After Refresh
Community SupportHi YL_TCI,
Thank you for sharing the detailed findings.
A few checks from the Microsoft documentation that may help troubleshoot this behavior:
• Check Semantic Model permissions: Paginated Reports that use Power BI Semantic Models require Read permission on the underlying Semantic Model. This is also required when the report and Semantic Model are in different workspaces.
• Check the data-source configuration: Verify that the Paginated Report is configured with the expected data source and that the connection and credentials are configured correctly. The embedded data-source guidance also recommends using Test Connection to verify that the data source is available and the specified credentials are correct.
• Check the error message: Microsoft documents specific session and connection errors, including "Your session has expired," "Error communicating with Analysis Service," and "There was an error when attempting to create a new session." The appropriate troubleshooting depends on the error displayed.
• Check network connectivity: If the error indicates a network connectivity issue during session creation, Microsoft recommends checking the network configuration, including VPN settings, network policies, and firewall rules, to ensure that nothing is blocking the browser from connecting to the Power BI service.
• If the Semantic Model uses DirectQuery: Paginated Report queries using a Power BI DirectQuery Semantic Model have a fixed 10-minute timeout. For queries that take longer than 10 minutes, Microsoft recommends using the Semantic Model's XMLA endpoint as the report data source.
• Check the browser if applicable: For the documented Chrome 142 session-creation issue, Microsoft recommends trying Microsoft Edge or an earlier version of Google Chrome.
For more details, please refer to the below Official Microsoft Documentation:
• Troubleshoot Paginated Report Session and Connection Issues - Power BI | Microsoft Learn
• Create Embedded Data Sources for Paginated Reports in the Power BI Service - Power BI | Microsoft Learn
• Supported Data Sources for Power BI Paginated Reports - Power BI | Microsoft Learn
I hope this helps. Please feel free to reach out if you have any further questions.
Thank you.
Hi v-abhinavmu,
Thank you for your response.
Actually, I believe the case I experienced is a rather unusual one. I was hoping to get some technical support, but unfortunately, whenever I try to submit a support ticket, the page keeps redirecting me to the general troubleshooting articles and the standard checks you mentioned.
In my case, all of my Paginated Reports were working normally and had a valid connection to their Semantic Models before the Semantic Model refresh. Also, I’ve refreshed the Semantic Models many times in the past, and this has never caused the Paginated Reports to lose their connections before.
What makes this case even more unusual is that creating a new Paginated Report, which was not actually related to the problematic report, somehow caused the existing report to regain its connection to the Semantic Model.
That seems quite strange, right?
I’d be happy to work with a technical support engineer the next time I encounter the same issue, so we can hopefully capture more details while it is happening.
For now, the connection issue with my reports has been resolved in a unpractical way, and I’ll continue to monitor the situation.
Thank you again for taking the time to respond and help!
- v-abhinavmu
Hi YL_TCI,
Thank you for the detailed update. I’m glad to hear that the connection issue with your Paginated Reports has been resolved.
I appreciate you sharing your observations and continuing to monitor the behavior. Please feel free to share any further updates or findings that may help provide additional insight into the issue.
Thank you again for keeping the community updated.