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.
I added a new column in the source csv file (sharepoint), and when performed refresh data in power bi, alll data is getting updated except this new column.
Can someone pls guide what can be done to get the new column added as well.
Thanks
Solved! Go to Solution.
Go to Advance editor, in the line "source = csv.document" you must be having one parameter for column for example column = <some value>, so could you please try to increase its number based on column numbers or try to set it as null. Hope it should fix your problem.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi Samarth,
I haven't made any changes in power query. There is an existing custom column, which is there before adding the new column in source file.
Thanks
@gauravg3 , If you refreshing on services then it will not work. Actually It will only fetch the data from previous source it will not add a new columns. For any metadata changes or structural changes, you have to refresh it in Power BI Desktop and then publish it.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
I've tried refreshing in PowerBI desktop as well, still no luck.
yes, I've verified the source file, and replicated this in a separate report as well and getting the same issue.
Go to Advance editor, in the line "source = csv.document" you must be having one parameter for column for example column = <some value>, so could you please try to increase its number based on column numbers or try to set it as null. Hope it should fix your problem.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Samarth_18
Could you pls advise what do you mean by increase its number value based on column?
Thanks
yes changing the column value worked 🙂 many thanks
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |