Unable to refresh due to error "Value cannot be null. Parameter name: source"

[kevalmgm]

Hello Community, 
I have been trying refresh data on Power BI Desktop and on every refresh it fails with same error randomly on any of the tables. 

Data load is from Amazon Redshift and it is a DirectQuery. 
Any help on this will be appreciated. 

[kevalmgm]

Hello @amitchandak 
The member table and LA_LAE_left ha *:* bi-directional relation as the data model is a relational one. So is there a need to convert that to Dimensional model. The report and data is being poulated correctly, only issue is refresh data. 

[v-kkf-msft]

Hi @kevalmgm ,

This error looks like the correct data source could not be found. Please follow this document https://docs.microsoft.com/power-query/connectors/amazonredshift  to reconnect to Amazon Redshift using the correct connection string.

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

[kevalmgm]

Hello @v-kkf-msft. 
Did go through the mentioned link and everything looks good there. 
Not sure, what is th ecat issue

[amitchandak]

@kevalmgm , Is member used as dimension. It is on one side or one to many join. Then check are you getting a blank value for the join column. Open power query and check