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 guys,
I'd want to parameterize the file path with language M but I can't.
For example:
I have a file Excel in a folder C:\PBI\WORK so in editor I have
let
Origine = Excel.Workbook(File.Contents("C:\PBI\WORK\File_01.xlsx"), null, true),
data_Table = Origine{[Item="data",Kind="Table"]}[Data]
in
data_Table
After, I have created a parameter
Name: PathFile
Type: Text
Current value: C:\PBI\WORK
So, how can I change language M to set the parameter?
Thank you all
Solved! Go to Solution.
@giuliapiazza94 , Create an M Parameter, say path (under manage parameter, create new)
let
Origine = Excel.Workbook(File.Contents(path &"\File_01.xlsx"), null, true),
data_Table = Origine{[Item="data",Kind="Table"]}[Data]
in
data_Table
@giuliapiazza94 , Create an M Parameter, say path (under manage parameter, create new)
let
Origine = Excel.Workbook(File.Contents(path &"\File_01.xlsx"), null, true),
data_Table = Origine{[Item="data",Kind="Table"]}[Data]
in
data_Table
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |