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.
Hi team,
I am having trouble with this:
I have 13 CSV files as my power BI data source, growing on a weekly basis, but now i have 4 additional columns. How do i tell power BI that he should have let's say these 4 columns to the full dataset and populate the previous files with let's say null values.
thanks,
Solved! Go to Solution.
The best option for this is to change the file that you use as your transformation file, that way when you append the files using the custom function the columns will be filled with null.
You just need to edit the step Navigation on the Sample File:
= Source{0}[Content]
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
The best option for this is to change the file that you use as your transformation file, that way when you append the files using the custom function the columns will be filled with null.
You just need to edit the step Navigation on the Sample File:
= Source{0}[Content]
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you Miguel!
that did the job very easily and now I learned a new option 🙂
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |