Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
User | Count |
---|---|
60 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
40 | |
39 |