Forum

Hi Mike, That's odd as we would have very similar regional settings and I am able to import the CSV file with no problems using 365. Of course, ...

Hi Andrew, Can you please share your file? Be sure to click the 'start upload' button after selecting your file. Mynda

Hi Marc, Yes, but as I explained above, if you load the data to a table and then build a PivotTable from it you must Refresh All twice, once for t...

Hi Catalin, I downloaded your archive and changed the file path to point to my PC and I get the error I mentioned above. Mynda

Hi Yvonne, I don't know what the data represents, but attached are a couple of options. Hope that helps. Mynda

In a folder I have 3 files, one of which is open. I 'get files from folder' in a new workbook and when I click the double down arrow on the Content co...

Hi Ajith, Not sure why it's not loading for you. I was able to load it. See file attached. Mynda

Hi Kishan, Welcome to our forum! Power Query can't navigate to the other pages because they're generated by JavaScript, rather than having a spe...

That's interesting, Catalin. However, I still get errors when trying to get data from folder where one or more of the files are open. ‍

Best to reference the tables as opposed to the sheets if you can.

Hi Tim, You are jumping the gun a bit 🙂 I cover this scenario in 6.07 of the Power Pivot course, but if you go straight to that video you're m...

Hi Graham, You didn't misread my comment. There seems to be vastly different experiences for getting data from a workbook between your version of E...

Hi Kyrstin, I tested on SharePoint too and it worked fine. Here is a tutorial on getting data from SharePoint folders with Power Query. Note: as...

Hi Mick, You'd need to add data for the missing years. See example file attached. Mynda

Hi Graham, Thanks for clarifying that the tests were done on the same file. One thing to confirm, you cannot get data from an open Excel workbook, ...