Forum Discussion

mp390988's avatar
mp390988
Post Partisan
8 months ago
Solved

Error fetching data for this visual

Hi,   Can someone please help me as I have been tiredlessly trying to resolve this strange issue on my report.   Some of the visuals are displaying an error message saying "Error fetching data fo...
Need Help
  • v-menakakota's avatar
    v-menakakota
    8 months ago

    Hi mp390988 

    Thanks for reaching out to the Microsoft fabric community forum.

     

    I would also take a moment to thank danextian    , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
    Yes, users must have at least Read (Viewer) access to the Profit semantic model, or the visuals that trigger queries will fail.

    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

     

    Best Regards, 
    Community Support Team

mp390988's avatar
mp390988
Post Partisan
8 months ago

Hi danextian ,

I am not sure how to do a direct query to another semantic model so I don't understand when you say I'm using a DirectQuery to a semantic model. All I did was Get Data > Power BI semantic models > then selected only 3 tables out of 10 from that semantic model.

 

Then what I did was created 3 calculated tables based on those 3 tables i picked from the pre-exisiting semantic model. I used SELECTCOLUMNS. This then means I can now view the data in the Table View and these tables are stored automatically as Import. 

 

All my visuals uses fields from the calculated tables and not directly from the tables from the semantic model, if that makes sense?

 

Thank You

  • danextian's avatar
    danextian
    Super User
    8 months ago

    When your model already contains data, connecting to a Power BI semantic model forces DirectQuery. A live connection does not allow you to select tables, and it only occurs when the model is completely empty - no imported tables, no calculated tables, no DirectQuery sources, and no unloaded queries. With a live connection, you also cannot create new columns or modify relationships; all of that must be done in the source semantic model. If it were a live connection, you would see a message in the bottom right saying “Connected live to the Power BI semantic model: <name> in <workspace>.”

    • v-menakakota's avatar
      v-menakakota
      Community Support
      8 months ago

      Hi mp390988 

      Thanks for reaching out to the Microsoft fabric community forum.

       

      I would also take a moment to thank danextian    , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
      Yes, users must have at least Read (Viewer) access to the Profit semantic model, or the visuals that trigger queries will fail.

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

       

      Best Regards, 
      Community Support Team

      • v-menakakota's avatar
        v-menakakota
        Community Support
        8 months ago

        Hi @mp390988 ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

         

        Best Regards, 
        Community Support Team