![]() 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. |