Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Mixed Storage Mode - End users not able to see visuals

Hello - I've published a mixed storage mode report, it works perfectly fine in the PBIX files but the end users aren't abe to access it. The data sources are a Power BI Live Dataset that I had to switch to Direct Query due to adding an excel file. The excel file is accessed through the Sharepoint File service and is Import storage mode. The end users have all been added to the security that the Power BI Live Data set was built with, and have share access to that report.  Do they need to have additional security to the direct query?

 

Here are the data sources for reference

And the error messages that the end users see

 

 

Need Help

4 Replies

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    4 years ago

    If I understand your architecture your users need build permission on the original dataset. A lot of people have suggested this is a big problem

    with composite models but I don't think it has been resolved yet.