Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
BarryASeymour
Advocate I
Advocate I

Value cannot be null. Parameter name: evaluation - Amazon Redshift

I have a working query that pulls records from Amazon Redshift. When I paste that query into a new Data Source I get the error. 


Value cannot be null. Parameter name: evaluation

I tried deleting the ExceptionCache - no luck.

I reported this through the Power BI "Report This Issue" feature, but at their suggestion I'm also posting it here.

I'm trying to figure out how to post the error log..

 

8 REPLIES 8
BarryASeymour
Advocate I
Advocate I

I have found my own solution, documented above. No need to ask me any more, thanks.

Anonymous
Not applicable

Hi @BarryASeymour,

We trust that your issue has been resolved. Please update the worked solution here and mark it as "Accept as Solution." Additionally, give it a 'Kudos' to help others find it easily.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

Anonymous
Not applicable

Hi @BarryASeymour,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Regards,
Pavan.

Anonymous
Not applicable

Hi @BarryASeymour,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

BarryASeymour
Advocate I
Advocate I

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.

BarryASeymour_0-1736978836595.png

 

Anonymous
Not applicable

Hi @BarryASeymour,

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.

BarryASeymour
Advocate I
Advocate I

I still have the issue. I deleted/reinstalled PBI, still have the issue.  Server and credentials are correct. When I create a new query and attempt to put custom SQL in the step I get the error.
However, I have found a workaround:

  • Create a new blank PBIX
  • Open Power Query Editor, create a new Query
  • Enter Amazon Redshift server and database name
  • Enter credentials if needed
  • Select an existing dataflow
  • Leave it as DirectQuery, not Import
  • Query creates successfully
  • Return to the first Applied Step ("Source") in the Query and update it, inserting the SQL command
  • Delete the "Navigation" Applied Step

This gives me the query I want. I repeated this step four times to give me four queries, each based on custom SQL.

I still don't know why it fails when I do it the first way.

I would love to attach the error log, but that doesn't seem to be an option here.




Anonymous
Not applicable

Hi @BarryASeymour,

Thank for reaching out in Microsoft Community Forum.

Please follow below steps to acheive the error;

1. please make sure no null and missing parameters in the query

2. confirm the connection string, credentials, all required permissions are correct or not and all query parameters are defined and used correctly.

3. Delete and set up the Amazon Redshift data source again in Power BI.

If you are still experiencing the issue, please reply with a screenshot, and we will work on resolving your query.

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.

Thank you,
Pavan.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors