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

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 I
Helper I

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
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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors