Forum Discussion

zehmenezes's avatar
zehmenezes
New Member
1 year ago
Solved

Embedded Report Not Displaying Data (Using two semantic models as direct query)

Hi all, 

 

I do have some PBI Reports Embedded in my company. All of them work just fine, except for one that I've tried to "mix" semantic models inside it. It's not showing any specific error, just this in all graphics.

 

 

When I click to see details, this is what I receive (nothing that actually helps):

 

Error fetching data for this visual

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.Hide details
  • Hi zehmenezes ,

    Yes, you can embed Power BI reports that uses composite models into your company’s website with a few important considerations.

    Composite models allow you to combine imported data with DirectQuery sources, including Power BI semantic models, Azure Analysis Services, and SQL Server Analysis Services.

    The main limitation is: DirectQuery to Azure Analysis Services is not supported in Power BI Embedded. If your composite model includes this type of connection, embedding will fail.
    Also make sure to

    • Embed tokens properly.
    • Ensure that all data sources used in the composite model are accessible to the embedding context.
    • Use Premium capacity if your report relies on advanced features like large models or DirectQuery to Power BI datasets

    Hope this helps!

    If the response has addressed your query, please accept it as a solution so that other members can easily find it.
    Thank You.

8 Replies

  • Hello zehmenezes 

     

    The message “Error fetching data for this visual” usually pops up when something’s blocking the visual from retrieving its data

     

    Have you checked the below posts:

     

    1.  Solved: Re: Error fetching data for this visual - Microsoft Fabric Community?

     

    2. Power BI tile error: Couldn't retrieve the data for this visual. Please try again later. — Fred's Data Adventure

     

    Regards,

    Ritesh

    Community Champion

    Please mark the answer if helpful so that it can help others

    Dance-Sing with Data Projects - YouTube

     

     

     

     

  • your users must have registered ("installed") both apps from the participating semantic models before this will work.

    • zehmenezes's avatar
      zehmenezes
      New Member

      there's only one app in my company and this app works for all my pbi embedded reports (have more than 20 PBIs published).

  • v-sdhruv's avatar
    v-sdhruv
    Community Support

    Hi zehmenezes ,

    In addition to this you can check for direct query credential issue.When combining semantic models with other data sources (e.g., SQL or Excel), credential mismatches or certificate validation errors can prevent visuals from loading. This is  common when the semantic model uses direct lake and falls back to DirectQuery due to unsupported features.

    https://learn.microsoft.com/en-us/fabric/known-issues/known-issue-985-direct-lake-query-cancellation-fall-back-directquery

    Check and update credentials for each data source in Power BI service. Also, try to 

    switch to composite models.Instead of live connections, use composite models that combine imported and DirectQuery data. 

    If still you are facing the isssue consider posting in issues forum here-
    https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

    Hope this helps!

    • zehmenezes's avatar
      zehmenezes
      New Member

      Hello v-sdhruv. This is a PoC file, I only have these two sources:


      The data is coming from two sources as shown, but they are both hosted in the same Fabric Worskpace. About changing it to "Composite Models": am I going to be able to embed it in my company's website after migrating?

       

  • v-sdhruv's avatar
    v-sdhruv
    Community Support

    Hi zehmenezes ,

    Just wanted to check if you had the opportunity to review the suggestions provided?
    If the response has addressed your query, please accept it as a solution so that other members can easily find it.
    Thank You.

  • v-sdhruv's avatar
    v-sdhruv
    Community Support

    Hi zehmenezes ,

    Yes, you can embed Power BI reports that uses composite models into your company’s website with a few important considerations.

    Composite models allow you to combine imported data with DirectQuery sources, including Power BI semantic models, Azure Analysis Services, and SQL Server Analysis Services.

    The main limitation is: DirectQuery to Azure Analysis Services is not supported in Power BI Embedded. If your composite model includes this type of connection, embedding will fail.
    Also make sure to

    • Embed tokens properly.
    • Ensure that all data sources used in the composite model are accessible to the embedding context.
    • Use Premium capacity if your report relies on advanced features like large models or DirectQuery to Power BI datasets

    Hope this helps!

    If the response has addressed your query, please accept it as a solution so that other members can easily find it.
    Thank You.

  • v-sdhruv's avatar
    v-sdhruv
    Community Support

    Hi @zehmenezes ,

    I hope you got some clarity with the suggestion provided.
    If you still have questions,  feel free to reach out.
    If the response has addressed your query, please accept it as a solution so that other members can easily find it.
    Thank You.