Custom SQL from script

[fuxit]

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 script instead of input a SQL query so that I could manage the query centrally from outside of PowerBI?

Best regards,

Jens

[amitchandak · Accepted solution]

@fuxit , refer if these can help

https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269

https://stackoverflow.com/questions/37589448/how-to-use-sql-server-stored-procedures-in-microsoft-po...

https://medium.com/@cagataycevikk/executing-stored-procedure-with-parameter-on-power-bi-b677d485166a

[simrantuli]

Hi @fuxit ,

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