cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smireles
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

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.

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

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

 

 

 

SQL Server Connection- LINPRM.PNG

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

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.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Kudoed Authors