cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

How can I set Data Queries to be loaded in a worksheet named as the query itself?

Hello!

 

How can I set Data Queries to be loaded in a worksheet named as the query itself?

 

E.g. I have Query1 and when I run/refresh it, I want the results to be loaded in a worksheet named Query1, instead of Sheet1.

 

Thanks!

6 REPLIES 6
New Member

I don't believe there is a way to autoname the worksheet you load your query to.   

There might be an Add On tool someone created which may do this, but I don't use these as my laptop is restricted from those.

I would recommend renaming your worksheet prior to or after you do your first load to the worksheet and when you refresh in the future, it will automatically load to that particular worksheet.  Of course, if you rename the query you will have to manually rename the tab.  Theoretically, it should be a rare occurrence where you would need to rename since you are refreshing vs. creating a new query each time.

Community Support
Community Support

@UsePowerBI 

Can you provide a screenshort and explain what you have done like where is Query1 (power bi desktop?) and to which worksheet(Date view?Excel?). And I am not sure what do you mean by run/refresh to load data into sheet, also which worksheet do you meant?

 

Regards
Paul

Solution Sage
Solution Sage

if you mean when loading the query you can go to power query editor, there doble click the query name and it will let you change its name

Thanks but I do not want to change the Query name. I want to change (or better specify) the Sheet name to be the same as the Query name.

you mean the sheet on the report view? if that it, same doble click on the sheet name of the report and you can rename it, but thats manually cant do it by default or anything. 

Solution Sage
Solution Sage

hey, the question its a bit ambiguous can you post a example of what you mean exactly? the end result you want. 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors