cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smireles Frequent Visitor
Frequent Visitor

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!

 

 

 

Binding errors PBI_LI.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Invalid Object name error

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.

4 REPLIES 4
Community Support Team
Community Support Team

Re: Invalid Object name error

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

 

Highlighted
smireles Frequent Visitor
Frequent Visitor

Re: Invalid Object name error

 

 

SQL Server Connection- LINPRM.PNG

Community Support Team
Community Support Team

Re: Invalid Object name error

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.

Community Support Team
Community Support Team

Re: Invalid Object name error

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