Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
shelbsassy
Resolver I
Resolver I

Need to change SQL in data source

I need to make some changes to the SQL statement I have as a Direct Query using SQL Server in Power BI.  What is the best way to go about doing this without losing all my relationships and connections?  Should I create a new data source using the updated code and then do change data source?  When I look at the query in the advanced editor there are a lot of symbols between the fields that power bi adds so I don't think I can just copy and paste into that window?  Any thoughts would be appreciated I would hate to have to rebuild these dashbards from scratch.  THank yoU!

1 ACCEPTED SOLUTION

@shelbsassy So first, cut a copy of your desktop PBIX file and save it as a seperate file. Use that file to mess around with so you aren't so worried about destroying your report.

You can easily access the original query by going to edit queries and clicking on the wheel icon next to the "Source" in the Applied Steps pane on the right hand side. This will open the original prompt and you can copy/paste the new code in there.

 

As long as the new query includes the columns you are already using you shouldn't have any issues with things breaking. You would do this for each query you have, as each would have their own SQL code I assume. (If you have multiple queries and you are worried about relationships breaking)


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2

@shelbsassy So first, cut a copy of your desktop PBIX file and save it as a seperate file. Use that file to mess around with so you aren't so worried about destroying your report.

You can easily access the original query by going to edit queries and clicking on the wheel icon next to the "Source" in the Applied Steps pane on the right hand side. This will open the original prompt and you can copy/paste the new code in there.

 

As long as the new query includes the columns you are already using you shouldn't have any issues with things breaking. You would do this for each query you have, as each would have their own SQL code I assume. (If you have multiple queries and you are worried about relationships breaking)


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer Thank you for your reply!  Just what I needed!  Saved me a lot of work!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.