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 guys,
I have 10 excel files in a folder. I am trying to connec to the folder from Power Bi but in Power Query after I choose Combine and Transform some specific columns from some excels i see them as Nulls but in the excel file are not Nulls.
I tried to align all the excels files by making all the columns as text (The columns which have the problem are text, is actually text with number e.g AG284/4), but again is not working.
In the meanwhile if i connect to a specific excel (only to this), power query loading normally all the columns.
I know that i can load the excels and combine them through the append queries, but i prefer this solution so to navigate my colleagues just to bring me the file in the folder.
Also the excel files are all in the same format (.xlsx)
Does anyone has any idea why this happen ?
Instead of using the built-in Combine function you can create your own process - create a function that ingests an excel file (and maye forces all columns to text) and then use "Add column - from custom function" to fetch all the content. Then throw away unneeded columns and finally expand the function column.
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |