cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dbrandone
Helper III
Helper III

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

3 REPLIES 3
dbrandone
Helper III
Helper III

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

parry2k
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

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 Solution Authors
Top Kudoed Authors