I have some reports based on a dataset which have a csv file for source.
I recently added 10 columns to my source file and I'd liked to actualize my table in PBI to see those new columns but without losing all my mesures etc...
I successfully updated the data but I don't see the new columns in PBI desktop in my dataset...
Someone can help me?
Thank you in advance.
Go to Solution.
Thank you @AndrejZitnay , I finally found my solution in one of the topic you provide me.
To see my new columns in my source, I modify a the value for "Columns" in the advanced editor :
View solution in original post
You need to click on Refresh after updating your data source.
thank you for your answer.
I did refresh after updating my datasource but I don't see any update in my PBI source...
I've added some columns to my csv file and I don't see those.
The file is at the same place as before.
I don't understand why I'm not able to update the structure of my file...
There are two options.
1st - can you change your file to .xlsf format.
Refresh will work fine and give you new columns
2nd - Here are few tips
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!