Forum Discussion

LondiweThusi's avatar
LondiweThusi
Regular Visitor
6 months ago
Solved

Embedded Power BI composite report – DirectQuery semantic model visuals not loading

Hi everyone, I’m facing an issue with an embedded Power BI composite report and would appreciate any guidance. Scenario: The report uses two data sources: A Fabric semantic model (DirectQuery...
one lake
  • v-prasare's avatar
    v-prasare
    6 months ago

    Hi  LondiweThusi,

    This behavior strongly aligns with how embedded evaluates identity and permissions in composite models, especially when DirectQuery-to-semantic-model is involved. Even though the report works in the Fabric portal and all dataset IDs are included in the embed token, the embedded runtime still validates effective permissions for each underlying semantic model at query time. In embedded scenarios, this identity propagation across semantic models is more restrictive and can fail silently, surfacing as a generic QueryUserError, even when no RLS or gateway is configured.

     

    Microsoft documents these limitations and troubleshooting steps here:
    https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-troubleshoot


    Additionally, SQLBI explains how permissions are evaluated in composite models and why every referenced dataset must independently resolve access for the embedded identity:
    https://www.sqlbi.com/blog/marco/2021/06/03/setting-the-right-permissions-for-users-of-composite-models/

     

     

     

     

     

    Thanks,

    Prashanth

suparnababu8's avatar
suparnababu8
Super User
6 months ago

Hi LondiweThusi 

 

I can understand your problem. As I'm using my Power BI report with import mode., embedded into Web applictaion, it's working fine. I'm not imlemented the Direct Query embeded Power BI in web application. Based on your problem let me share my thoughts as follws.

  • As per your error 'Failed to move the data reader to the next row' , it means PBI tried to execute the Direct Query but it doesn;t retrive rows from the source. The same is working for import mode becuse of data is cached. So, Hope it caused by missing dataset authorization in the embed token.
  • Cross check, make sure that your embedded token include all dataset ids such as composite datset and upstream semnatic modles. Use the GenrateTokenGroup API with datsets array covering every datatset
  • If you're appled any RLS, pass effective identites in the embed configuration. Make sure to confirm embeded identity has Read access to the semantic model.
  • As of now there is no limitation for compostite models.
  • Also, if your DirectQuery source is on premises, please configure gateway properly. 

 

Please let know if this helps you

 

Thank you!!

 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!