Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Question with SQL and Power BI

Hi Everyone,


I am just starting in Power BI, but have good knowledge and expertise with SQL. Right now my work has a SQL database that has real time replication that is controlled by an organization that we contract with for health records. It is a long story on the control of that database but that is for another time. Anyway, I created my own instance of SQL and linked into the other database. That way I can control views and data from there. For right now, the database is held locally until I build the foundation and then it will be moved into an Azure VM. I have been testing the connections with Power BI and Visualizations with the data I have pulled. If I have Power BI open with data retrieved and then open Azure Data Studio, then everything works fine. When I update views in ADS and then refresh the data in Power BI, I get a network instance error. I then will close out of ADS, close out of Power BI and I will still have a network instance error. It is not until I restart my computer that I can get Power BI to successfully connect to the SQL data.


Any help would be appreciated. Thanks

Helper II
Helper II

Wanted to push this question out to everyone again. If anyone has any ideas why this happens and if there is a fix for it or not. Thanks everyone

Super User III
Super User III

@dbrandone are you using SQL views in power bi or what? 

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

yeah, I have views built and access them in Power BI. Since I am referencing a separate database in my sql instance through linked server, I felt that was the best way. I'm the only one with access and I am not refreshing Power BI at the same time that I am altering tables or anything.

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors