Forum Discussion
Value cannot be null. Parameter name: evaluation - Amazon Redshift
It's happening again. This time I can't even get to the custom SQL part. I enter the server and database name, click OK and I get the error.
Did all of the above, no change. No query parameters yet.
FWIW this is in a PBIX that already has one working connection with a custom query.
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps reslove your issue;
1.Test the query in a SQL client to ensure it's correct and make sure all query parameters are properly defined and check for null values in power BI.
2. please recheck the server name, database that the amazon Redshift connector is used.
3. If the data source is corrupted, delete and recreate the connection using the Redshift connector, then clear the Power BI cache by deleting the files from the specified folder. Restart Power BI.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and select "Yes" if it was helpful. help other members find it more easily.
Regards,
Pavan.