Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All the paginated reports published in a Premium per User workspace that has worked properly for months, cannot be seen anymore since this week. The error is the following
A data source used by this report returned an error. Received error payload from gateway service with ID 35903: AdomdException encountered while accessing the target data source.. A system error occurred inside the Analsyis Services instance. AdomdException encountered while accessing the target data source. Error del sistema:. Learn more: https://aka.ms/pbiservicegatewaylearnmore.
Attached the snapshot of the error:
Additional comments:
- Regular Power BI reports pointing to the same data source still works properly
- Reports can still be properly seen when running through the Report Server desktop version
None of those solutions worked for now:
- Updating Report Server version
- Reseting Report Server service
- Reseting Gateway
- Publishing again the reports
This error message indicates that there is an issue with the connection to the data source used by the paginated reports. There are a few things you can try to resolve the issue:
Check the data source connection: Make sure that the data source connection is still valid and that the credentials used to connect to the data source are correct.
Check the gateway: Make sure that the gateway is configured correctly and that it is running properly. Check the logs for any errors or warnings related to the data source connection.
Check the Analysis Services instance: Make sure that the Analysis Services instance used by the paginated reports is running properly and that there are no errors or issues with the instance.
Check the permissions: Make sure that the users have the correct permissions to access the data source and the paginated reports.
Check for updates: Make sure that both Power BI and the Report Server are up to date.
Check the firewall: Make sure that the firewall is not blocking the connection between Power BI and the data source.
Check the network: Make sure that there is no network issue that is preventing Power BI from connecting to the data source.
Try to recreate the data source: Sometimes the issue is related to the data source, try to recreate the data source, and check if the error is still appearing.
If none of the above solutions work, it's recommended to open a support case with Microsoft to get further assistance.
It's also important to check the Power BI and the Report Server logs for more details about the error and provide this information to the support team.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |