Forum Discussion

Arthemis_Runner's avatar
Arthemis_Runner
Frequent Visitor
2 years ago
Solved

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

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"     Powe...
Need Help
  • Arthemis_Runner's avatar
    Arthemis_Runner
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Arthemis_Runner
Frequent Visitor
2 years ago

Thanks  for the response Anonymous.

 

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.