cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

 

Best regards,

Jens

1 ACCEPTED SOLUTION

Accepted Solutions
2 REPLIES 2
Highlighted
Responsive Resident
Responsive Resident

Re: Custom SQL from script

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors