Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Source: Azure Blob Storage
Source = AzureStorage.Blobs("xxxxxxdev001")
JSON data is coming from Azure Blob Storage and JSON files are PostgreSQL Server Diagnostics Logs:
let
Source = AzureStorage.Blobs("xxxxxxdev001"),
#"insights-logs-postgresqllogs1" = Source{[Name="insights-logs-postgresqllogs"]}[Data]
in
#"insights-logs-postgresqllogs1"
Error Details:
DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value={
Position=470
When I try to navigate through Binary, getting above error - not sure why? 😥
No, I haven't attempted it for a while, but I've been working on an alternative approach to reformat the JSON using Python and then passing the file to analyzer. Please let me know if you have any opportunities to resolve it.
In Power Bi Desktop its working fine for me, in service i m getting issue
@azeem2020 , this error come when the json format has some issue. some character is not required or missing position
Those JSON files are being generated automatically by enabling Diagnostic Setting on PostgreSQL - Flexible Server.
Configure and Access Logs for Azure Database for PostgreSQL - Flexible Server - JSON format
So I assume, JSON is well formatted otherwise Microsoft should rework on their format. But here in my case - the issue is somewhere else.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |