Forum

Can you upload a sample file with the structure you described?

You can add another step, to remove duplicate rows, this way you will still have all columns. The key columns that needs to be selected to remove d...

Hi Aye, The recipe is simple: 1. Process a single xml file (Get Data From xml file), the query Source step should look like: Source = Xml.Tab...

From the query, I guess that you are using the automatic combiner, which is not a good idea most of the times. I' sure you have received this advice b...

the xml is a text file, any text editor will open it. Catalin Bombea said Hi Aye, Without seeing how are you processing the files, it's impossibl...

Hi Aye, Without seeing how are you processing the files, it's impossible to provide an advice. Upload your query.

Hi, You can copy the Group By step formula, remove that step and use instead a new column with the Group By formula. This way, you can expand on...

Hi, Power BI desktop has an option to import data from PDF files. Use the From Folder option, and make sure you have those pdf files in that folder...

Hi Dan, There are still some things not very clear: WK09 is a week number? If so, why you have the Start Date in week 9, when the end date 27/05...

Hi Rajsha, Add your table to power query, then add a new column with this formula: = Table.AddColumn(#"Changed Type", "Count", (x)=> Table....

Hi Mourad, Here is the code for that part: ' Problem is in following 4 steps If objCollection(i).Type = "submit" And objCollection(i).Value ...

Glad to hear you managed to make it work. By the way, the last file source data is completely different to the initial file provided, I thought tha...

Hi Chris, Already asked "Can the end date be in a different month than start date?", but did not saw a clear answer for this question, so I assumed...

Try this query (remove last column from the existing table): let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Extracted Day" = T...

Hi Steven, You don't need a form password to do that, there is no such thing. Collect user password with a text inputbox, check it, and if it's ...