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.
I ran into the same thing, but got it to work. My scenario is taking data from Stream Analytics in Azure to a Data Lake Store using JSON fragments into folders named by date and by hour. In the query editor I navigated to the folder that contains the JSON files and selected "Combine Files", then I added a Transform to Parse the data as JSON. After that sample enough of the data to get all the column names (we have multiple record types which result in a sparsely populated matrix). After you have the data looking as you want close and apply the changes.