Forum Discussion
Wrong error message (A connection could not be made to the data source)
I'm using Power BI Desktop to update a semantic model from 2021. I need to update the name of the database server. After doing...
Transform data
Data source settings
select the data source
click Change Source...
correct the value in Server
OK
Close
Apply changes
...I get this error message.
Cannot load model: We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permission to access them.
ProviderMessage: <ccon>A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"oldservername","database":"databasename"},"authentication":null,"query":null}'.</ccon>
I have manually checked...
Transform data | Data source settings
File | Options and settings | Data source settings
...and the M for all 34 tables in the model to verify that "oldservername" exists nowhere in the .pbix file.
What's happening here? Where else to I need to change the server name?
---
I'm leaving this here for anyone who has this problem in the future.
It turns out a column had been removed from a table. I was also seeing this error message.
Expression.Error: The column 'ColumnName' of the table wasn't found.
Details:
ColumnName
Removing the column name from the semantic model caused Power BI to stop lying to me about not being able to connect to a server name that it wasn't even using.
All is well.
1 Reply
- d_m_LNK
Super User
anotherPBIAdmin - I would suggest separating your solition in your post and add it as a reply to your original question. That way you can mark the reply as the solution it will have a solution on this thread for others to find.