Mixed Storage Mode - End users not able to see visuals

[jdaily83]

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

[bcdobbs]

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.

[jdaily83]

That doesn't sound like a good idea at all! 

[bcdobbs]

https://ideas.powerbi.com/ideas/idea/?ideaid=cda81f12-5b9c-eb11-89ee-281878de0321 

We do make it work with that issue but...

• you have to make sure RLS and OLS are working well.
• your semantic model needs to be clean, well labeled etc

[jdaily83]

We have a pretty good RLS on it. I will speak to our IT guy tomorrow. It might make more sense for him to add the excel file to the actual dataset and then I can just connect to the Power BI Live Dataset then. They have the same data I need that they can pull directly from Oracle but often times it takes months to get things automated. Which was why I was attempting this work around in the first place.