cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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
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

Microsoft
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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors