cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mr89 Helper I
Helper I

Custom column in Power Query (M)

Hi all,


I have kind of a funky thing here. I have a report connected to some folders, with Excel files, including the name of the folders and excel files as a column in my query is no issue, however, I also want to create a column that contains the name of the PBIX file I am working in. This needs to be dynamic, i.e creating a column hard coding the name of the PBIX file is not an option because the file will be copied and the name changed depending on the period.

 

The reaon I need the name of the PBIX file as a column, is so I can match up the PBIX file with the relevant files in my source folders dynamically. 

 

Anyone have any ideas on this?

 

Thanks!

 

Best,

 

Morten

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-cherch-msft
Microsoft

Re: Custom column in Power Query (M)

Hi @Mr89 

You may try to load .pbix files from folder.For further,please follow this article.

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Microsoft v-cherch-msft
Microsoft

Re: Custom column in Power Query (M)

Hi @Mr89 

You may try to load .pbix files from folder.For further,please follow this article.

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Microsoft v-cherch-msft
Microsoft

Re: Custom column in Power Query (M)

Hi @Mr89 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mr89 Helper I
Helper I

Re: Custom column in Power Query (M)

Hi, yes this worked. You can actually refer to the same file you are working in via folder withouth getting any circular argument errors. 

 

Thank you!

 

Best regards,

 

Morten

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors