We have an Azure Data Lake Store which receives data from the EventHub every minute. We are trying to generate a report in Power BI Desktop application from this data. The data file in the Data Lake Store is a binary file with xx.avro extension as shown below. My question is, how can we convert this data into BI Table format to generate a graphical report?
Hi @v-jiascu-msft, Thank you for your response. I might be not clear in my earlier question. We were able to load the data successfully into Power BI from Data Lake Store. The question we have is on how we can convert the Binary data into a table format so that we can have reports from the data we receive every minute? A shown below in the first image, able to load the data. Each row has a Key/Value pair data received in "key":"value" format. When I generate a report out of this data, it comes as a single text in one field.
So we transformed the data into a Record type to be able to click on the Expand Icon as shown in the below image. When we click on the expand icon, we hoped to see all the 'keys' as column names. but no luck!
This is how we would like to convert our data into (Table format)