Forum Discussion
Data access issue with mixed storage model
Hi, all,
I created a power BI report with pure "direct query" mode linking to an existing power BI dataset. It works well and users can use this report even they don't have access to the original report (dataset).
But when I created another report, in which I added some data tables and linked to the same PBI dataset by direct query. This time it became "mixed model" becuase I have a local dataset. Then weird thing happended, users couldn't see the visuals I created. I tried many mehthods to resolve it. Seems that the only way is that I need to grant these users access to that dataset, which is not realistic.
Does anybody has experience to share? Thanks a lot!
(1) If the report is pure "direct query", there is no issue:
(2) With "mixed" storage mode, users can't see the visuals.
Hi Anonymous ,
Yes, this is a known limitation:
//Build permissions are required to view reports built using this feature when one or more datasets in the chain are in Pro workspaces. If the creator a report has left the company or their Build permissions has been revoked since they created the report, Build permissions will also be required on all datasets in the chain.
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
So currently users cannot properly view reports modeled in this mode without build access. Or consider using direct query mode to connect to a data source instead of a dataset and then import the data to create a report.
This feature is still in preview and it would be helpful if you could pass your feedback on to the product team.
Share your thoughts on DirectQuery for Power BI da... - Microsoft Power BI Community
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi, Gao,
Much appreciate your help, the article you shared is very useful!
I also found anothe problem which is I can't set the credential for the "local" dataset with "composite mode" (mixed storage mode), which means even users can see the data from direct query dataset, I won't be able to refresh the import part (local dataset).
I have figured it out this problem has already been addressed in the "Considerations and limitations" section, just above the tip you shared: Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
With all these findings, I have to draw a conclusion that mixed storage mode (composite mode) is not mature for real projects.
I'm trying the following 2 approaches instead:
(1) Pure "Direct Query mode" for multiple datasets: I'll create a separated dataset for the "local" part, and then create a report connecting to all these datasets.
(2) Import data from the existing dataset.
Will share the results soon.
6 Replies
Hi Anonymous ,
Yes, this is a known limitation:
//Build permissions are required to view reports built using this feature when one or more datasets in the chain are in Pro workspaces. If the creator a report has left the company or their Build permissions has been revoked since they created the report, Build permissions will also be required on all datasets in the chain.
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
So currently users cannot properly view reports modeled in this mode without build access. Or consider using direct query mode to connect to a data source instead of a dataset and then import the data to create a report.
This feature is still in preview and it would be helpful if you could pass your feedback on to the product team.
Share your thoughts on DirectQuery for Power BI da... - Microsoft Power BI Community
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi, Gao,
Much appreciate your help, the article you shared is very useful!
I also found anothe problem which is I can't set the credential for the "local" dataset with "composite mode" (mixed storage mode), which means even users can see the data from direct query dataset, I won't be able to refresh the import part (local dataset).
I have figured it out this problem has already been addressed in the "Considerations and limitations" section, just above the tip you shared: Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
With all these findings, I have to draw a conclusion that mixed storage mode (composite mode) is not mature for real projects.
I'm trying the following 2 approaches instead:
(1) Pure "Direct Query mode" for multiple datasets: I'll create a separated dataset for the "local" part, and then create a report connecting to all these datasets.
(2) Import data from the existing dataset.
Will share the results soon.