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.
Hello,
i am trying to remove columns that contain the Suffix of sourceid , I did the code, but it seems it does not work an error message appeared like Expression.SyntaxError : Jeton Comma attendu. here you have the code below any recommendations,s, please?
= let
= let
Source = Excel.Workbook(File.Contents("C:\Users\kheir\Desktop\pratique Power BI\Formation 1\Product.xlsx"), null, true),
rawdata= Source{[item="clientData",kind="table"]}[DATA]
removeSources=Table.RemoveColumns(Rawdata,List.Select(Table.ColumnNames(Rawdata),each Text.EndsWith(_,"source")))
in
removeSources
Solved! Go to Solution.
Hi @pedrogarcia,
A comma is missing at the end of this line:
rawdata= Source{[item="clientData",kind="table"]}[DATA]
If you put it manually, it should solve the problem.
Kind regards,
John
Hi @pedrogarcia,
A comma is missing at the end of this line:
rawdata= Source{[item="clientData",kind="table"]}[DATA]
If you put it manually, it should solve the problem.
Kind regards,
John
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.