Forum Discussion
dmbaron
6 years agoFrequent Visitor
DAX Function Help Connecting to JSON Files
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 ...
- 6 years ago
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:
v-diye-msft
6 years agoCommunity Support
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: