Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
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.
Solved! 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 :
Hello @Anonymous
You need to click on Refresh after updating your data source.
Hi AndrejZitnay,
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...
Hello @Anonymous
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
https://community.powerbi.com/t5/Desktop/Add-an-extra-field-from-a-data-source/td-p/35681
https://community.powerbi.com/t5/Desktop/New-column-in-source-not-appearing-in-dataset/td-p/329649
Andrej
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 :
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |