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 want to create a summary report of Report A which is in Workspace A in Workspace B. It seems to me the best way to do this would be to create Report B that uses the Power BI dataset of Report A. However, the desktop will not let me publish it to Workspace B. It doesn't even ask. It just publishes it to Workspace A by default.
So my only alternative is to republish report A directly into Workspace B, but visuals redone with just the summary data I want. But now I have two reports pulling the exact same data through our Gateway, which seems horribly inefficient.
I cannot figure out the logic of not allowing workspaces to use report datasets from other workspaces, assuming all permissions are allowed of course.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi
Glad to see the coming version could help you!
It's very generous of you to share here!
Best Regards
Maggie
FWIW - this is going to be fixed in March 2019 it seems, which is good timing for my project. See this article for info on the "shared and certified datasets."
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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.