Forum Discussion

apacheco05's avatar
apacheco05
Frequent Visitor
1 year ago
Solved

Error fetching data for this visual

Hi,   I have a Direct Query table simple report. I'm just showing the data in a simple table without any transformation or measure. In the PBXI works fine but when I publish it and try to access it...
Need Help
  • apacheco05's avatar
    apacheco05
    1 year ago

    I took a new pbxi file and build everything again and now it is working. I really don't understand what was wrong with that pbxi file.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi apacheco05,

 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

Could you please try these Troubleshooting Steps:

Check Snowflake Query History If the query doesn't appear, the issue is within Power BI or the gateway.

Verify Gateway and Data Source Mapping Ensure the dataset is using the correct gateway and credentials in Power BI Service.

Review the Snowflake View Avoid using session variables, default parameters, or complex types like VARIANT in views.

Check Filters and Slicers Make sure no visuals are passing null or unassigned filter values.

Use Performance Analyzer in Power BI Desktop Capture and test the generated SQL directly in Snowflake to identify failures.

For Troubleshooting the issue verify the link : https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.

 

Thank you & regards,
Prasanna Kumar