Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 6 years ago
Anonymous , refer if these can help
https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
https://medium.com/@cagataycevikk/executing-stored-procedure-with-parameter-on-power-bi-b677d485166a
simrantuli
6 years agoContinued Contributor
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