Forum Discussion
Invalid Object name error
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!
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
MaggieCommunity 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.
4 Replies
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
MaggieHi 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
MaggieCommunity 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.
