Added ending bracket to JSON?

[szklanym]

Hi,

i'm using Azure Stream Analytics to store events into JSON BLOBs, while the file is being written the ending bracket is missing.

This means that i can't use Power BI to read my data for a whole day.

e.g.

[

{data_1...},

{data_2...},

...

MISSING END BRACE

Is there away to add the missing ] before trying to parse the file?

Best Regards

Mikkel

[szklanym]

Hi,

Thanks for the reply, I'm using the desktop version since we are storing nested json objects, which are only shown as records in the online version.

So the issue is wenn Reading json blobs in the Desktop App.

[v-jiascu-msft]

Hi @szklanym,

Is it like below? If so, I'm afraid we can't solve in Power BI Desktop side. The Desktop can't even parse it. 

Best Regards,

Dale

[v-jiascu-msft]

Hi Mikkel,

I think we should solve it in the source of the error. 

1. Where are the JSON BLOBs stored?

2. Why not connecting to Azure Stream Analytics directly since it's a stream data source?

3. Did you do it in the Desktop? Which connector?

Best Regards,

Dale

[szklanym]

Hi,

i'm using Azure Stream Analytics to store events into JSON BLOBs, while the file is being written the ending bracket is missing.

This means that i can't use Power BI to read my data for a whole day.

e.g.

[

{data_1...},

{data_2...},

...

MISSING END BRACE

Is there away to add the missing ] before trying to parse the file?

Best Regards

Mikkel