Invalid Object name error

[smireles]

I am trying to connect to a view called LINPRM that is pulling from different tables through the SQL Server Database connection. The database I am connecting to is a replication our main database so when our software is getting updates they have to turn off the replication. They did an update and now I am getting this error. My IT guy has rebuilt the replication from scratch twice and we keep getting no results. Let me know if anyone has a solution to solve this. Thanks!

[v-juanli-msft]

Hi @smireles 

Do you want to use the view in Power BI?

Please share me some screenshot or code how you connect to SQL with Power BI.

Best Regards
Maggie

[smireles]

[v-juanli-msft]

Hi @smireles 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @smireles 

It sounds like the view was created and then one of the underlying tables was changed. I.e.,

“Dbo.MBPatientCoverageLink”no longer exists or was renamed.

This article introduces more about this problem and gives some suggestions to solve the problem.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.