Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Dear community,
I get my report from a connected .xlsm from a sharepoint. I had to add 3 columns to the basic data of the .xlsm file. Unfortunately the columns are apparently not recognized in PowerBI after the refresh. But I need these 3 columns urgently for the evaluation. I have tried many hours but I can't find an appropriate solution for the problem on my own or in the forum.
Can anyone please help me?
Thanks a lot in advance,
Andi
Solved! Go to Solution.
Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@AP_BI
Can you open the file directly from SharePoint and check if you can see those newly added columns?
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello @Fowmy
yes, that works perfectly fine. I tried it with Sharepoint Folder as well as Excel offline source and there is no problem with the added columns.
Probably I have to change some of the applied steps (refer to the picture). As you can see the Sharepoint has lots of different files. I filtered for .xlsm as it is the only file I want to use. After that I removed top rows. But the last 3 columns from source data are missing.
Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |