Forum Discussion

timazarj's avatar
timazarj
Icon for Helper II rankHelper II
2 years ago
Solved

couldn’t retrieve the data for this visual

Hi 

I share a report with several people within the organization. Two of them received the "couldn’t retrieve the data for this visual" error and could not see the table visualizations. The file is not very big and only has two tables. 

 

Thanks,

  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from vanessafvg , please allow me to provide another insight:

     

    Hi timazarj ,

     

    If the data source is connected by direct query, you need to make sure that the local data gateway is working properly.

    If the gateway is abnormal, it will result in visual not being able to fetch the dependent data via query. For reference.

    after stop on-premises gateway, visual get error:

     

    For more details, you can refer to below document:

    DirectQuery in Power BI - Power BI | Microsoft Learn

    Troubleshoot gateways - Power BI | Microsoft Learn

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    is your data source a direct query to another power bi modell?

  • The data sources are cloud based excel and a Sql table that import to the power bi.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply from vanessafvg , please allow me to provide another insight:

     

    Hi timazarj ,

     

    If the data source is connected by direct query, you need to make sure that the local data gateway is working properly.

    If the gateway is abnormal, it will result in visual not being able to fetch the dependent data via query. For reference.

    after stop on-premises gateway, visual get error:

     

    For more details, you can refer to below document:

    DirectQuery in Power BI - Power BI | Microsoft Learn

    Troubleshoot gateways - Power BI | Microsoft Learn

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.