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.
Hi,
This is our set-up:
- We have 2 SSAS-instances (DEV and LIVE)
- We have a few datasets in Power BI Service that each connect to a cube from one of these instances
- We have set up and configured a gateway to refresh the datasets
This set-up seems to work; when we refresh a report, we get new data.
But we've noticed that the datasets don't automatically refresh. We've configured in the settings from the datasets that a scheduled cache refresh should happen daily, but when we look at the refres history, we see that this refresh always fails.
When we try to refresh the dataset manually, we get the following error:
Something went wrong
An unknown error has occurred. Please try again. If the issue continues, please contact support.
Please try again later or contact support. If you contact support, please provide these details.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: b8f97a71-4c9e-4f1e-891f-800e403e17d5
Request ID: 81d656aa-4454-7684-40a1-ff2c227c36b0
Time: 2019-10-07 09:47:48Z
Some more info:
-The gateway is running and all connections with the datasources are successfull.
-The cubes have processed and are available.
-We've tried changing the interval for the scheduled cache refresh, but this doesn't change anything.
Can someone help us to solve this issue?
Thanks.
Kind regards,
Ward
Hi
Thank you for your respons. The input you gave is very valuable for sure.
But whether it is a report or a dashboard that needs to refresh, we still need the error to be fixed.
Kind regards,
Ward
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.