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