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.
I have a report that connects to Dataset A and Dataset B in direct query mode. I do not have any other data sources in that report.
After publishing the report in a shared workspace (which is other than MyWorkspace), the report only works fine for the Owner group.
But as soon as I share the report with end users, they see the following error in all the visuals. Any advice will be highly appreciated please.
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.
Hide details
Solved! Go to Solution.
Hi @RxG
I was about to reply and say that the users need to be members of the workspace or if the datasets are in separate workspaces then the users need to be also members of those 2 workspaces.
Now, External users to consume your report means 2 solutions, Either you give them or add them as guests to your workspace with at least a Pro license or the workspace itself needs to move from shared capacity to premium capacity.
Here is a link to Limitations
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @RxG ,
For app workspace, you can only grant build permission for Dataset A and Dataset B for users that you want to share the DQ report to .
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I am having the same or very similar problem. Very keep on finding a solution so please post any information you get here!
Just to add bit of further information.
In a normal report that is pulling data from one Power BI dataset in LIVE Connection mode, when the report is shared with end users the link works fine for them.
But if the same report is upgraded to pull data from two Power BI dataset in DirectQuery mode then the link stops working for them. Further, when I add the end users as members in the workspace, it again starts working for them.
The problem is that we can't add all the users in our workspace. We are expecting some external users also to be consuming this report in near future.
Hi @RxG
I was about to reply and say that the users need to be members of the workspace or if the datasets are in separate workspaces then the users need to be also members of those 2 workspaces.
Now, External users to consume your report means 2 solutions, Either you give them or add them as guests to your workspace with at least a Pro license or the workspace itself needs to move from shared capacity to premium capacity.
Here is a link to Limitations
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
can you please help by giving some info about this link: whats it hitting, source etc
https://wabi-us-central-b-primary-redirect.analysis.windows.net/powerbi/metadata/models/217555/?mode... ?
What is this link? Access denied.
What is your question?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973,
We have reports published into a pro-licensed workspace. We are using these reports in an application. The Problem is when applying filters or logging into the application as a user, one of the report shows visuals with error: "
Couldn't retrieve the data for this visual. Please try again later.
Thank you Amine. Looks like you have well pointed out worspace upgrade. I think we haven't upgraded the workspace and hence are having to add memnbers to the workspaces. I already had the build access setup on the datasets in the chain though.
I will give it a go and will update you here. I suspect it might take a bit of time as I will need to work with others to assess and implement this change. Once that has been fixed I will come back here and update you.
Thank you again so much.
Hi @RxG
Not sure if by saying Dataset A and Dataset B you mean by Source A and Source B, because you can't build a single report from 2 datasets.
Lets assume you meant by Source A and source B, in that case in Direct Query mode Data must come from a single source. So I am guessing that is the issue you are having.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you Amine for the quick response.
These are the steps I did to create the report:
1) I created Report A / Dataset A in import mode using various sources including third party APIs, SQL Database Tables, excel files etc.
2) I then created Report B / Dataset B in import mode separately. Both these reports are working fine in every way including the user access.
3) I then enabled the preview feature namely "Direct Query for PBI datasets for PBI Datasets and AS as follows:
File -> Options and Settings -> Global Preview Features -> Direct Query for PBI Datasets and AS.
4) I then created report C in direct query mode that connects to Dataset A and Dataset B. This became possible after enabling the above preview feature. This report works fine in PBI desktop and even in the portal any users that belong to the owner workspace can see this report perfectly.
The error only shows up when users within the organisation who have been granted access to this report but are not members of the owner workspace try to access this report.
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.