Custom SQL from script
Hello, I know that I can connect to an SQL Server and use expand "Advanced options" to input a SQL query to pull in the data that I want. Would it also be possible to provide a link to an SQL scr...
Forum Discussion
Hi Anonymous ,
I don't think you can do that.
But what you can do is create a view in SQL and just use that view in Power BI.
So, whenever you want to modify your query, you can just make the changes in the view in SQL itself. You wouldn't need to edit the same in Power BI.
Best Regards
Simran Tuli