Forum Discussion
Rename multiple columns via a function or bulk edit
I have a problem when I bring my data into PowerBi it removes all the spaces in the column name and it assigns the column name as caml casing. for example one of the questions could be: "I Have Ques...
Hi Anonymous
My apologies. I missed your reply.
Please see the attached file. I modified your query.
Please go to Query Editor and see Table1
Anonymous
Did it work?
Hi Anonymous,
There is a newer version of API. Did you try it? Did you change it from 15 to 14 manually?
Source = SharePoint.Tables("https://mytenant.sharepoint.com/sites/sitecollection/", [ApiVersion = 14])
Best Regards,
Dale
yes, unfurtunately the newest version has a bug and it cuts off all the column names and that is why I used version 14.