Hello All, I have develop a power bi report and upload it onto power bi service. Two tables are loaded from excel files from sharepoint, three power bi datasets in the same workspace are imported via DirectQuery Mode. I could see all the visuals on my own account on power bi service. But for other users in the same workspace, visuals only using data from DirectQuery datasets works fine, but visuals using data from both DirectQuery datasets and sharepoint excel loaded tables reports the error 'Couldn't load data for th visual'. The details are copied as follows:
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 19879f8c-5da0-4cf8-89b6-8a4bc5b6072d Request ID: a3ee8f0a-f1ba-4cf1-9ddf-b17d097f485a Correlation ID: cc48d325-9125-950a-8805-955a8c3713f5 Time: Wed Mar 01 2023 10:17:23 GMT+0800 (China Standard Time) Service version: 13.0.20148.59 Client version: 2302.3.12445-train Cluster URI: https://wabi-north-europe-c-primary-redirect.analysis.windows.net/
Does anyone know what kind of mistake I have made or any possible solutions to this issue? Many Thanks.