Value cannot be null. Parameter name: key - Power BI Semantic Model

[Arthemis_Runner]

I am getting this error on one specific report. I am unable to add a new data source or change the current data sources. I get the error: "value cannot be null. Parameter name: key"

Power BI Version: 2.132.1053.0 64-bit (August 2024)

Troubleshooting attempts:

- Cleared all permissions

- Signed out and signed back in

- Uninstall and reinstall PBI version

User Story:

- Open pbix file in power bi desktop

- Click transform data and select Data Source Settings

- Select required data source and click change data source

- double click replacement semantic model.

- Select required tables and click submit

- Error is thrown while data is trying to load.

[Arthemis_Runner · Accepted solution]

I had to delete each model "piece" by piece" to identify which one was causing the issue. Then I deleted that one and recreated the columns and connections.

I'm not really sure what was going on with that particular model. Hopefully someone figures it out.

[v-fenling-msft]

Hi, @Arthemis_Runner 

I am glad to help you.

May I ask what type of data source you are using? What type of data source do you modify to when you modify the data source?

Based on your error message, perhaps you can check your data source for null values and make sure that all required parameters and fields are filled out correctly, especially the connection string.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arthemis_Runner]

Thanks  for the response @v-fenling-msft.

Both data sources are power bi semantic models via direct query. The current model is in our development workspace and the target is our production workspace.

I connected a blank pbix file to the production dataset and it worked perfectly. Also, I tried just adding an excel file data source to the original file and I got the same error.