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.
Dear Comunity,
I am learning and appling PowerBi, Power Query, PowePivot into my business life. This is my first post therfore it may look easy but I could not find proper solution...
My Question is two part first part is the subject, actually I found the issue but I could not find solution;
- Our customer send every week their sales reports in excel or csv, I have just started to use PowerQuery to combine them but I realised different "table names" causes this error; some excel report sheet name are "prijmy_vydeje_skladem (005)", some prijmy_vydeje_skladem (009), etc.
When I change the name manually, The reports have the same sheet names are recognised by Power Query and not get error for that table...
How can I solve this issue first, there are 53 reports for each previous report.
I will be pleased, if you can you help.
Best regards,
Note: I use File/Folder as New Source in Power Query and locate the folder contains weekly reports
Solved! Go to Solution.
Hello Greg,
Thank your for your advice. After many hour spent I found the soluiton and applied on my case with little modification, it isueful and easy. Here is the solution Combine Files With Inconsistent Columns In Power Query
Hi,
I have the same issue, did you find a solution?
Hi Lalilonso,
I put the solution video link in latest message, if it does not solve could you give an example?
Hmm, not fun. Power Query is very touchy about its names. @ImkeF or @edhans may have suggestions.
Hello Greg,
Thank your for your advice. After many hour spent I found the soluiton and applied on my case with little modification, it isueful and easy. Here is the solution Combine Files With Inconsistent Columns In Power Query
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |