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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nietzsche
Helper IV
Helper IV

Is there a way to get PQ or M code to display the name of the workspace and dataflow instead of ID?

hello all, 

 

Is it possible to get Power Query/M code to display the name of the workspace/dataflow instead of their ID so that it makes it easier for me to know where the table is located in?

 

Nietzsche_0-1718148394091.png

 

Thanks

1 ACCEPTED SOLUTION
Joe_Barry
Solution Sage
Solution Sage

Hi @Nietzsche 

 

I don't believe there is.

What you can do is when you bring the table in, is to leave a note in the mquery. In a new line you can leave the workspace name like

/// Business Intelligence

 

If you want to find out which workspace it is, then copy the id and put it in this url and search in your browser

https://app.powerbi.com/groups/youridhere/

 

Hope this helps

Joe




I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



View solution in original post

2 REPLIES 2
v-tianyich-msft
Community Support
Community Support

Hi @Nietzsche ,

 

Unfortunately.Power Query/M itself does not directly support fetching or displaying workspace or dataflow names within the query editor or through M code.You can manually add comments within your M code to annotate the names of workspaces or dataflows.

 

If you would like to suggest feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team_ Scott Chang

Joe_Barry
Solution Sage
Solution Sage

Hi @Nietzsche 

 

I don't believe there is.

What you can do is when you bring the table in, is to leave a note in the mquery. In a new line you can leave the workspace name like

/// Business Intelligence

 

If you want to find out which workspace it is, then copy the id and put it in this url and search in your browser

https://app.powerbi.com/groups/youridhere/

 

Hope this helps

Joe




I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.