Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Anonymous
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,
Hi @Anonymous
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,
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
Hi @Anonymous
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |