Data Privacy Levels in Power BI Report Server

[jsilva24]

Hi,

We are attempting to host a power bi file that uses a datasource (Web.Contents) that then feeds some identifiers to another Query that uses the same datasource. In Power BI desktop, we are immediately met with the Privacy concern and an error until we relax or ignore privacy settings. The error is below

Once we pass that, we can work in power bi desktop just fine. Our issue comes when we attempt to publish this on power bi report server, set up everything, and refresh. We get an error like below

[Unable to combine data] Section1/VizNeglectedWIP/Expanded productWipDuration1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.. The exception was raised by the IDbCommand interface.

In power bi online, I have dealt with this issue throught the api as we are allowed to set the privacy levels with the api. However after checking the reporting server api, there seems to be nothing related there. I then found this in the documentation shared below that says data privacy levels are not supported in power bi report server and to use Role Definitions. We tried exploring it but no approach has been found.

Any ideas on how to overcome this?