Forum Discussion
Pro workspaces can't load Fabric data for some users
Anonymous Sorry for the trouble on this one! Turns out I was misunderstanding the permissions. The users needed to be added to the Data-warehouses / Lake-houses that data originated from (as viewers) in order to have access to downstream reports / data-sets (I thought they'd just need access to the semantic models in the lineage, based on misunderstanding the docs). We should be able to rework our approach slightly to make this easy to manage.
I'm still a bit confused on how the semantic model connections to the Analysis Service are designed to work, but for the time being this specific problem (data not loading) seems to be solved.
It seems like it might be similar to this issue in the Power BI forum: Solved: ISSUE+SOLUTION::published report Fabric datasource... - Microsoft Fabric Community
The linked doc suggests that the behavior I'm seeing is intended, based on the default Personal Cloud Connection that was setup when the report was published. This differs from past publishing (that I remember) in that the default option will only allow users to query the data-source using thier own credentials (not the report creator's).
The issue with this is (assuming I've guessed correctly) that following the recommended workflow (setting up a new connection as described in the documentation) is encountering a different error - the created connection fails to provide access to the dataset. Seems to be an open issue with Power BI: Premium_ASWL_Error - Single sign-on (SSO) credenti... - Microsoft Fabric Community
I've tried removing calculated columns (I remember this has cause issues with the Power BI Service and Direct Query before), but no dice. Will probably try speaking to Support tommorow, since I haven't found a way to share reports that use Fabric data without needing to add users to all upstream data-sets (which isn't going to work for us, it'd be impractical to service firmwide reports with this kind of limitation).
Hi Anonymous
Apologies for the issue you have been facing. Please go ahead with Microsoft support on this.
https://support.fabric.microsoft.com/en-US/support/
After creating the ticket please provide the details here which would help us for internal tracking.
Thanks