DAX Function Help Connecting to JSON Files

[dmbaron]

Hello - I'm trying to create a function using the instructions in this page...

https://www.dutchdatadude.com/loading-multiple-json-files-using-power-query/

However, I get the following error message which I don't understand, what do you think?

Thank you in advance.

An error occurred in the ‘LoadJSON’ query. Expression.Error: The key didn't match any rows in the table.
Details:
    Key=
        Folder Path=https://XYZ.blob.core.windows.net/foldername
        Name=Log_20200518_030000.json
    Table=[Table]

[v-diye-msft · Accepted solution]

Hi @dmbaron 

It's a typical case would be when you connect to an Excel file and then your Query attempts to access a Sheet that does not exist in the Spreadsheet.

You might refer to the other blog to connect to JSON files:

https://powerbloggerbi.com/2016/03/02/import-multiple-json-file-in-power-query/ 

And the similar threads for more hints:

https://community.powerbi.com/t5/Desktop/Get-multiple-json-files-from-Onedrive-folder-into-powerbi/t... 

[amitchandak]

@dmbaron , refer if these can help

https://community.powerbi.com/t5/Desktop/expression-error-when-importing-json-data-with-variable-con...

https://community.powerbi.com/t5/Desktop/Expression-Error/td-p/395412

https://www.youtube.com/watch?v=ipI6mrWLQKA