Forum Discussion
json in Azure Data Lake as data source in Power BI
I am seeing the same issue. I navigated to the json file within a folder inside data lake store. Once i click on the file it automatically tries importing it as a csv. I remove the import csv steps and changed type steps it automatically creates. Then on the navigation step i can now select to import JSON. I then get the following error. The JSON file was created by using a copy pipeline from an on Prem SQL Server table to Data Lake Store as JSON using Data Factory.
Something to try in your query on the json fragments - when editing the query, go up to the directory that has all the files and click the link to combine the files, then add a Transform to parse the dataset as json. After that you need to sample the headers to get the column names/types for the json data.