Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
Hi @smireles
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.