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.
Hello everyone]!
I have a data in power bi that is composed of several excel files all in the same folder. Each time I add a new file, power bi automatically joins them. so far everything's fine. The problem is that the last column of my data, is not reading it to me, that is, in PB says "null" where there should be data. Well if I check in the data in Excel there is indeed data in the last column and it does not say null. I want to add that all my files have the same format, i.e. the same number of columns and the same title.
From now on thank you very much and if you know a way to automatically join files from the same folder I would be grateful
hi @CLCastroEn
It should be removed by some operations, for example: Romove other columns.
Go to edit queries, please check each steps that at which step this column missed, and then adjust this step code.
If you still have the problem, please share a simple sample pbix file and your sample excel file. that will be a great help.
Regards,
Lin
@CLCastroEn - Check that your Sample File query isn't doing anything weird like filtering out all values or something in that column. If you didn't have that column originally and then added it, there is a good bet that it is not being picked up or you did a transformation on and forgot about it. Check Advanced Editor and your Source line.
@CLCastroEn , what is the format of the file. Does last column have some data
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |