Power BI M (power query) 1 min.

// Get rid of Helper Queries in Power Query - JSON edition

Generic Load JSON to Power BI

I recently wrote about an approach to dynamically load CSV files to Power BI through Power Query without the engine to clutter up the UI in Power BI with helper queries.

You can read it here.

The approach also had some functionallity for getting the first file and traversing the headers automatically. This has now been re-coded to fit a folder from your source containing JSON files.

The JSON file structure is somewhat easier to handle, as it is using the Json.Document functionality within Power Query.

The cure for JSON

As with the CSV import file and the generic approach - here is a similar apporach for JSON.

NOTE that the approach below only handles the first level of data in your JOSN file. You need to handle the file with more lines of code of you have nested JSON

Happy coding 😊.