Forum

This function is used in the query, you can see what arguments are sent to this function. KeyList is a ... list. You can put {"Key","Key2"} to ...

See file attached for an example.

Hi Peter, Using the automatic file combiner from folder is not flexible, try following the instructions and sample files from this topic: Instead of...

If you don't see a specific pivot in Report Connections list of pivots, they have a different cache. You can try running the cache reset codes provide...

So you will have around 30 DefTables and 30 Map tables, the Maps might have that Name_To_Skip text? I assume the corresponding tables will have the...

Hi Matthias, Dir works on local file system. An online sharepoint folder is not local, it's online (obviously). From web, you have to download t...

I don't see errors in the code. With Advanced Editor open, if you press Show Error, what section of code gets highlighted?

Copy again the GetNextPageData function from above, was missing an opening [ just before RelativePath. Copy again the changes indicated, each line ...

let Source = Excel.CurrentWorkbook(){[Name="SourceTable"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Topology", type text}, {"T...

Should be possible, but hard to say how without seeing the page structure, all depends on the web page structure.

Why using separate tables for each parameter? You can put all parameters in a single table, see image attached. You will then be able to use a...

Why not using Power Query to import csv data? It's much more powerful than TextToColumns. To make the current code work, you have to change your...

Hi Cherian, If the file was on your computer, you could use visual basic to schedule a code to run on a specific date, but if the file is not on yo...

Paste the query into a blank new query: (api_url, path, PageNumber, TotalPages, token)=> let JsonData = Json.Document(Web.Contents(api_url, [Rel...

Not everything you have in user interface can be used in vba, otherwise it will be a security issue. Think about permissions, if you can control these...