![]() ![]() ![]() To start editing the code hop over to the Advanced Editor (View àAdvanced Editor). Remember we need to create a function that will enable us to iterate over multiple files. We are not done however this was the easy part. To do this click the expand button to the right of the column header and click OK (I deselected the ‘use original column name as prefix’ option):Īnd voila: a nice looking table of the records in this JSON file: Next step is to expand the resulting Column1 to see some actual data. You will probably see a ‘to Table’ dialogue, allowing customization of the conversion for JSON you normally should not have to change the defaults, so click OK. What you want to do is convert the records into a table by clicking on the button: You will a one column table listing all records in the JSON file (the exact number of rows changes with the length of the JSON file): So first, click on ‘Binary’ in the first column for one of the rows representing a JSON file. To do this we use an approach similar to loading multiple Excel or CSV files (see here and here respectively): first we just load one file and then we convert it into a function which we will call for all files we want to load. ![]() What we will need to do is create a function that loads the JSON files. Select the container the data is in and choose Edit: Next, you will see a list of containers in the blob storage. You will need to enter your Azure Storage account name and key. In Excel, navigate to the Power Query tab, select From Azure à From Microsoft Azure Blob Storage: Just click Get Data à More in the Power BI Designer and then select ‘Azure’ and then choose Microsoft Azure Blob Storage and click Connect: You could do the same using Power Query in Excel.įirst, let’s connect to the blob storage. I will be using Power Query for this, from the Power BI Designer. My solution will not work for multiple containers. I am assuming all the files you want to load are in one container. The scenario: I have multiple JSON files sitting in a container in Azure Blob Storage I would like to load them all into a data model for use in Power BI. It turned out to be less easy than expected, so I figured it is worth blogging about… I had to figure out recently how to load multiple JSON files using Power Query. Loading multiple JSON files using Power Query ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |