Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi,
Please find the below screenshot -
We are trying to build a report from Snowflake using Power BI Report Builder.
We created a ReportQuery table and binded the parameters to generate the report but facing above issue as shown in the screenshot. Kindly, look into this and please share the valuable inputs that would be highly appreciable.
Thanks,
Sonali Sahu.
Hi, @Sonali_Sahu
Make sure that the dataset "ReportQuery" is defined correctly and that the query is valid. The query should be able to pull data from the Snowflake data source without any errors.
I noticed from the screenshot that you define the parameters "@ReportYear", "@ReportMonth", "@FromDate", "@ToDate", but you don't set their values. Make sure that these parameters are set correctly and passed to the query.
Verify that the connection to the Snowflake data source is configured correctly and working as expected.
Sometimes, if the report builder is idle for too long, it can cause some problems. Try closing and reopening Report Builder. You can refer to the following post:
Solved: Power BI report builder error when running the rep... - Microsoft Fabric Community
Ensure that the object names in the report definition are case-sensitive, CLS-compliant, and limited to 256 characters.
Troubleshoot paginated report execution issues - Power BI | Microsoft Learn
If the parameters and fields you want to visualize in the report are from the same dataset, try creating another dataset that is only used for parameters. you can check the following link:
Solved: Error message with paramaters Report Builder - Microsoft Fabric Community
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.