Hi
I have extracted a repor definition for an existing simple report and stored it in a lakehouse table by part both encoded and decoded
However when I try and use this to recreate the report in a different workspace I get the following error:
'status': 'Failed', 'createdTimeUtc': '2025-03-03T14:44:01.5991557', 'lastUpdatedTimeUtc': '2025-03-03T14:44:02.0210561', 'percentComplete': None, 'error': {'errorCode': 'Workload_FailedToParseFile', 'message': "Cannot read 'report.json'. After parsing a value an unexpected character was encountered: v. Path 'config', line 1, position 17."}
If i pass the extracted encoded string it works perfectly - not sure what is going wrong
Code is below with sensitive details replacd with XXXXXXX - any help greatly appreciated
import requests
import json
import time
import base64
workspaceID = "XXXXXXX"
reportName = "Test client publish 2"
reportDescription = "this should be filtered to 1211"
clientGroupCode = "1211"
#Should not need to change definition block
definitionElementName = 'definition.pbir'
definitionJson = '''{ "version": "4.0", "datasetReference": { "byConnection": { "connectionString": "Data Source=XXXXXXX;Initial Catalog=XXXXXXX;Integrated Security=ClaimsToken", "pbiServiceModelId": null, "pbiModelVirtualServerName": "sobe_wowvirtualserver", "pbiModelDatabaseName": "c2049598-3bae-4081-8941-32d80d4a6bca", "name": "EntityDataSource", "connectionType": "pbiServiceXmlaStyleLive" } }}'''
#Will need replacing each republish
themeElementName = 'StaticResources/SharedResources/BaseThemes/CY24SU10.json'
themeJson ='''{ "name": "CY24SU10", "dataColors": [ "#118DFF", "#12239E", "#E66C37", "#6B007B", "#E044A7", "#744EC2", "#D9B300", "#D64550", "#197278", "#1AAB40", "#15C6F4", "#4092FF", "#FFA058", "#BE5DC9", "#F472D0", "#B5A1FF", "#C4A200", "#FF8080", "#00DBBC", "#5BD667", "#0091D5", "#4668C5", "#FF6300", "#99008A", "#EC008C", "#533285", "#99700A", "#FF4141", "#1F9A85", "#25891C", "#0057A2", "#002050", "#C94F0F", "#450F54", "#B60064", "#34124F", "#6A5A29", "#1AAB40", "#BA141A", "#0C3D37", "#0B511F" ], "foreground": "#252423", "foregroundNeutralSecondary": "#605E5C", "foregroundNeutralTertiary": "#B3B0AD", "background": "#FFFFFF", "backgroundLight": "#F3F2F1", "backgroundNeutral": "#C8C6C4", "tableAccent": "#118DFF", "good": "#1AAB40", "neutral": "#D9B300", "bad": "#D64554", "maximum": "#118DFF", "center": "#D9B300", "minimum": "#DEEFFF", "null": "#FF7F48", "hyperlink": "#0078d4", "visitedHyperlink": "#0078d4", "textClasses": { "callout": { "fontSize": 45, "fontFace": "DIN", "color": "#252423" }, "title": { "fontSize": 12, "fontFace": "DIN", "color": "#252423" }, "header": { "fontSize": 12, "fontFace": "Segoe UI Semibold", "color": "#252423" }, "label": { "fontSize": 10, "fontFace": "Segoe UI", "color": "#252423" } }, "visualStyles": { "*": { "*": { "*": [ { "wordWrap": true } ], "line": [ { "transparency": 0 } ], "outline": [ { "transparency": 0 } ], "plotArea": [ { "transparency": 0 } ], "categoryAxis": [ { "showAxisTitle": true, "gridlineStyle": "dotted", "concatenateLabels": false } ], "valueAxis": [ { "showAxisTitle": true, "gridlineStyle": "dotted" } ], "y2Axis": [ { "show": true } ], "title": [ { "titleWrap": true } ], "lineStyles": [ { "strokeWidth": 3 } ], "wordWrap": [ { "show": true } ], "background": [ { "show": true, "transparency": 0 } ], "border": [ { "width": 1 } ], "outspacePane": [ { "backgroundColor": { "solid": { "color": "#ffffff" } }, "transparency": 0, "border": true, "borderColor": { "solid": { "color": "#B3B0AD" } } } ], "filterCard": [ { "$id": "Applied", "transparency": 0, "foregroundColor": { "solid": { "color": "#252423" } }, "border": true }, { "$id": "Available", "transparency": 0, "foregroundColor": { "solid": { "color": "#252423" } }, "border": true } ] } }, "scatterChart": { "*": { "bubbles": [ { "bubbleSize": -10, "markerRangeType": "auto" } ], "general": [ { "responsive": true } ], "fillPoint": [ { "show": true } ], "legend": [ { "showGradientLegend": true } ] } }, "lineChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ], "forecast": [ { "matchSeriesInterpolation": true } ] } }, "map": { "*": { "bubbles": [ { "bubbleSize": -10, "markerRangeType": "auto" } ] } }, "azureMap": { "*": { "bubbleLayer": [ { "bubbleRadius": 8, "minBubbleRadius": 8, "maxRadius": 40 } ], "barChart": [ { "barHeight": 3, "thickness": 3 } ] } }, "pieChart": { "*": { "legend": [ { "show": true, "position": "RightCenter" } ], "labels": [ { "labelStyle": "Data value, percent of total" } ] } }, "donutChart": { "*": { "legend": [ { "show": true, "position": "RightCenter" } ], "labels": [ { "labelStyle": "Data value, percent of total" } ] } }, "pivotTable": { "*": { "rowHeaders": [ { "showExpandCollapseButtons": true, "legacyStyleDisabled": true } ] } }, "multiRowCard": { "*": { "card": [ { "outlineWeight": 2, "barShow": true, "barWeight": 2 } ] } }, "kpi": { "*": { "trendline": [ { "transparency": 20 } ] } }, "cardVisual": { "*": { "layout": [ { "maxTiles": 3 } ], "overflow": [ { "type": 0 } ], "image": [ { "fixedSize": false }, { "imageAreaSize": 50 } ] } }, "advancedSlicerVisual": { "*": { "layout": [ { "maxTiles": 3 } ] } }, "slicer": { "*": { "general": [ { "responsive": true } ], "date": [ { "hideDatePickerButton": false } ], "items": [ { "padding": 4, "accessibilityContrastProperties": true } ] } }, "waterfallChart": { "*": { "general": [ { "responsive": true } ] } }, "columnChart": { "*": { "general": [ { "responsive": true } ], "legend": [ { "showGradientLegend": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "clusteredColumnChart": { "*": { "general": [ { "responsive": true } ], "legend": [ { "showGradientLegend": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "hundredPercentStackedColumnChart": { "*": { "general": [ { "responsive": true } ], "legend": [ { "showGradientLegend": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "barChart": { "*": { "general": [ { "responsive": true } ], "legend": [ { "showGradientLegend": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "clusteredBarChart": { "*": { "general": [ { "responsive": true } ], "legend": [ { "showGradientLegend": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "hundredPercentStackedBarChart": { "*": { "general": [ { "responsive": true } ], "legend": [ { "showGradientLegend": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "areaChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "stackedAreaChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "lineClusteredColumnComboChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "lineStackedColumnComboChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "ribbonChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ], "valueAxis": [ { "show": true } ] } }, "hundredPercentStackedAreaChart": { "*": { "general": [ { "responsive": true } ], "smallMultiplesLayout": [ { "backgroundTransparency": 0, "gridLineType": "inner" } ] } }, "group": { "*": { "background": [ { "show": false } ] } }, "basicShape": { "*": { "background": [ { "show": false } ], "general": [ { "keepLayerOrder": true } ], "visualHeader": [ { "show": false } ] } }, "shape": { "*": { "background": [ { "show": false } ], "general": [ { "keepLayerOrder": true } ], "visualHeader": [ { "show": false } ] } }, "image": { "*": { "background": [ { "show": false } ], "general": [ { "keepLayerOrder": true } ], "visualHeader": [ { "show": false } ], "lockAspect": [ { "show": true } ] } }, "actionButton": { "*": { "background": [ { "show": false } ], "visualHeader": [ { "show": false } ] } }, "pageNavigator": { "*": { "background": [ { "show": false } ], "visualHeader": [ { "show": false } ] } }, "bookmarkNavigator": { "*": { "background": [ { "show": false } ], "visualHeader": [ { "show": false } ] } }, "textbox": { "*": { "general": [ { "keepLayerOrder": true } ], "visualHeader": [ { "show": false } ] } }, "page": { "*": { "outspace": [ { "color": { "solid": { "color": "#FFFFFF" } } } ], "background": [ { "transparency": 100 } ] } } } }'''
#Will need replacing each republish - also replace the groupcode specified as a every page filter with ~@CLIENTGROUPCODE@~
reportElementName = 'report.json'
reportJson = '''{ "config": "{ "version ": "5.59 ", "themeCollection ":{ "baseTheme ":{ "name ": "CY24SU10 ", "version ": "5.61 ", "type ":2}}, "activeSectionIndex ":0, "defaultDrillFilterOtherVisuals ":true, "settings ":{ "useNewFilterPaneExperience ":true, "allowChangeFilterTypes ":true, "useStylableVisualContainerHeader ":true, "queryLimitOption ":6, "exportDataMode ":1, "useDefaultAggregateDisplayName ":true, "useEnhancedTooltips ":true}, "objects ":{ "section ":[{ "properties ":{ "verticalAlignment ":{ "expr ":{ "Literal ":{ "Value ": "'Top' "}}}}}], "outspacePane ":[{ "properties ":{ "expanded ":{ "expr ":{ "Literal ":{ "Value ": "true "}}}}}]}}", "filters": "[{ "name ": "2c6ae056070ab2a6c625 ", "expression ":{ "Column ":{ "Expression ":{ "SourceRef ":{ "Entity ": "_Protocol Hierarchy "}}, "Property ": "Client Group Code "}}, "filter ":{ "Version ":2, "From ":[{ "Name ": "_ ", "Entity ": "_Protocol Hierarchy ", "Type ":0}], "Where ":[{ "Condition ":{ "Comparison ":{ "ComparisonKind ":0, "Left ":{ "Column ":{ "Expression ":{ "SourceRef ":{ "Source ": "_ "}}, "Property ": "Client Group Code "}}, "Right ":{ "Literal ":{ "Value ": "200L "}}}}}]}, "type ": "Advanced ", "howCreated ":1}]", "layoutOptimization": 0, "resourcePackages": [ { "resourcePackage": { "disabled": false, "items": [ { "name": "CY24SU10", "path": "BaseThemes/CY24SU10.json", "type": 202 } ], "name": "SharedResources", "type": 2 } } ], "sections": [ { "config": "{}", "displayName": "Distribution Summary", "displayOption": 1, "filters": "[]", "height": 720.00, "name": "55ce982c2d156837951c", "ordinal": 1, "visualContainers": [ { "config": "{ "name ": "52adf0c83b93c68292a3 ", "layouts ":[{ "id ":0, "position ":{ "x ":9.888412017167383, "y ":0, "z ":0, "width ":1067.9484978540772, "height ":650.4377682403433, "tabOrder ":0}}], "singleVisual ":{ "visualType ": "lineChart ", "projections ":{ "Category ":[{ "queryRef ": "Operations - Distribution - Orders.Shipped Date.Variation.Date Hierarchy.Month ", "active ":true}], "Y ":[{ "queryRef ": "Sum(Operations - Distribution - Orders.Volume) "}], "Series ":[{ "queryRef ": "Operations - Distribution - Orders.Shipped Date.Variation.Date Hierarchy.Year "}]}, "prototypeQuery ":{ "Version ":2, "From ":[{ "Name ": "o ", "Entity ": "Operations - Distribution - Orders ", "Type ":0}], "Select ":[{ "HierarchyLevel ":{ "Expression ":{ "Hierarchy ":{ "Expression ":{ "PropertyVariationSource ":{ "Expression ":{ "SourceRef ":{ "Source ": "o "}}, "Name ": "Variation ", "Property ": "Shipped Date "}}, "Hierarchy ": "Date Hierarchy "}}, "Level ": "Month "}, "Name ": "Operations - Distribution - Orders.Shipped Date.Variation.Date Hierarchy.Month ", "NativeReferenceName ": "Shipped Date Month "},{ "Aggregation ":{ "Expression ":{ "Column ":{ "Expression ":{ "SourceRef ":{ "Source ": "o "}}, "Property ": "Volume "}}, "Function ":0}, "Name ": "Sum(Operations - Distribution - Orders.Volume) ", "NativeReferenceName ": "Sum of Volume "},{ "HierarchyLevel ":{ "Expression ":{ "Hierarchy ":{ "Expression ":{ "PropertyVariationSource ":{ "Expression ":{ "SourceRef ":{ "Source ": "o "}}, "Name ": "Variation ", "Property ": "Shipped Date "}}, "Hierarchy ": "Date Hierarchy "}}, "Level ": "Year "}, "Name ": "Operations - Distribution - Orders.Shipped Date.Variation.Date Hierarchy.Year ", "NativeReferenceName ": "Shipped Date Year "}]}, "drillFilterOtherVisuals ":true}}", "filters": "[{ "expression ":{ "HierarchyLevel ":{ "Expression ":{ "Hierarchy ":{ "Expression ":{ "PropertyVariationSource ":{ "Expression ":{ "SourceRef ":{ "Entity ": "Operations - Distribution - Orders "}}, "Name ": "Variation ", "Property ": "Shipped Date "}}, "Hierarchy ": "Date Hierarchy "}}, "Level ": "Year "}}, "filter ":{ "Version ":2, "From ":[{ "Name ": "o ", "Entity ": "Operations - Distribution - Orders ", "Type ":0}], "Where ":[{ "Condition ":{ "Comparison ":{ "ComparisonKind ":2, "Left ":{ "HierarchyLevel ":{ "Expression ":{ "Hierarchy ":{ "Expression ":{ "PropertyVariationSource ":{ "Expression ":{ "SourceRef ":{ "Source ": "o "}}, "Name ": "Variation ", "Property ": "Shipped Date "}}, "Hierarchy ": "Date Hierarchy "}}, "Level ": "Year "}}, "Right ":{ "Literal ":{ "Value ": "2019L "}}}}}]}, "type ": "Advanced ", "howCreated ":0, "isHiddenInViewMode ":false}]", "height": 650.44, "width": 1067.95, "x": 9.89, "y": 0.00, "z": 0.00 } ], "width": 1280.00 }, { "config": "{}", "displayName": "Org Structure", "displayOption": 1, "filters": "[]", "height": 720.00, "name": "ddf2c4cfa574fb65c4be", "visualContainers": [ { "config": "{ "name ": "5b4719a273a3cef6ed7b ", "layouts ":[{ "id ":0, "position ":{ "x ":12.085836909871245, "y ":35.1587982832618, "z ":0, "width ":581.2188841201717, "height ":672.4120171673819, "tabOrder ":0}}], "singleVisual ":{ "visualType ": "tableEx ", "projections ":{ "Values ":[{ "queryRef ": "_Protocol Hierarchy.Client "},{ "queryRef ": "_Protocol Hierarchy.Client Category "},{ "queryRef ": "_Protocol Hierarchy.Subsidiary "}]}, "prototypeQuery ":{ "Version ":2, "From ":[{ "Name ": "_ ", "Entity ": "_Protocol Hierarchy ", "Type ":0}], "Select ":[{ "Column ":{ "Expression ":{ "SourceRef ":{ "Source ": "_ "}}, "Property ": "Client "}, "Name ": "_Protocol Hierarchy.Client ", "NativeReferenceName ": "Client "},{ "Column ":{ "Expression ":{ "SourceRef ":{ "Source ": "_ "}}, "Property ": "Client Category "}, "Name ": "_Protocol Hierarchy.Client Category ", "NativeReferenceName ": "Client Category "},{ "Column ":{ "Expression ":{ "SourceRef ":{ "Source ": "_ "}}, "Property ": "Subsidiary "}, "Name ": "_Protocol Hierarchy.Subsidiary ", "NativeReferenceName ": "Subsidiary "}]}, "drillFilterOtherVisuals ":true}}", "filters": "[]", "height": 672.41, "width": 581.22, "x": 12.09, "y": 35.16, "z": 0.00 } ], "width": 1280.00 } ] }'''
#Should not need to change platform block
platformElementName = '.platform'
#authenticate
platformJson = '''{ "$schema": "https://developer.microsoft.com/json-schemas/fabric/gitIntegration/platformProperties/2.0.0/schema.j...", "metadata": { "type": "Report", "displayName": "az" }, "config": { "version": "2.0", "logicalId": "00000000-0000-0000-0000-000000000000" } }'''
token_string = mssparkutils.credentials.getToken("https://api.fabric.microsoft.com/")
header = {'Content-Type':'application/json','Authorization': f'Bearer {token_string}'}
#Build body
addbody = {
"displayName": reportName,
"description": reportDescription,
"definition": {
"parts": [
{
"path": definitionElementName,
"payload": base64.b64encode(definitionJson.encode('utf-8')),
"payloadType": "InlineBase64"
},
{
"path": themeElementName,
"payload": base64.b64encode(themeJson.encode('utf-8')),
"payloadType": "InlineBase64"
},
{
"path": reportElementName,
"payload": base64.b64encode(reportJson.encode('utf-8')),
"payloadType": "InlineBase64"
},
{
"path": platformElementName,
"payload": base64.b64encode(platformJson.encode('utf-8')),
"payloadType": "InlineBase64"
}
]
}
}
addURL = 'https://api.fabric.microsoft.com/v1/workspaces/' + workspaceID + '/reports'
add_Response = requests.post(addURL, headers=header, json=addbody)
print(add_Response)
if add_Response.status_code == 202 :
print("waiting")
finished = False
checkBody ={}
while not finished:
check_Response = requests.get(add_Response.headers['Location'],headers=header, data=json.dumps(checkBody))
checkData =check_Response.json()
if checkData['status'] == "Succeeded":
print("done")
finished = True
break
elif checkData['status'] == "Failed":
print("failed")
print(checkData)
finished = True
break
else :
print(checkData['status'])
