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.
We have a few reports that use a summary table of the below form:
Price Impact Summary Table = SUMMARIZE(Invoices, Invoices[Company], Invoices[CustomerGroup], Invoices[ItemCode], "YTD Price Impact", [Price Impact YTD])
Since 1st September, the refresh on these reports has been failing with a cryptic message.
Processing error: An unexpected exception occurred.
Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Activity ID: be862ba5-27b8-4360-9758-afb5cc26a9ac
Request ID: bb9bd8fc-63b0-40f5-a8d4-b29b33bb0eb3
Time: 2018-09-05 11:39:42Z
We suspect there is an issue with the service, we have worked around for now. The PBI desktop had no issues with these and was successfully refreshing. PBI service had no issues until 1st Sep and worked fine for a couple of months.
Please look into it if possible.
Hi sanimesa,
Please follow troubleshooting steps below:
1. Check if the power bi service is still running on the server.
2. Check if the on-premises gateway or personal gateway has been updated to the lastest version.
3. Check if you have configured the data source correctly in the session of "Manage Gateway".
4. If you have selected "SSO" option, please cancel it and try again.
Regards,
Jimmy Tao
@v-yuta-msft Verified that the error is not gateway related. We have 50+ reports and only 5 had this issue. Something changed to the service in September.
Hi sanimesa,
Couldn't reproduce your issue, I would receommend you to create a support ticket here: https://powerbi.microsoft.com/en-us/support/.
Regards,
Jimmy Tao
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.