The deployed workbook fails to load with Json error. about microsoft-defender-for-cloud HOT 6 CLOSED

Hi @SumeshP
which workbook is your issue referring to?

from microsoft-defender-for-cloud.

@TomJanetscheck
I am referring to https://github.com/Azure/Azure-Security-Center/tree/master/Secure%20Score/Get-SecureScoreData
This also deploys a workbook.
https://techcommunity.microsoft.com/t5/azure-security-center/secure-score-over-time-power-bi-dashboard/ba-p/1799954#:~:text=With%20our%20new%20Power%20BI,in%20your%20score%20over%20time.

from microsoft-defender-for-cloud.

Adding @amitmag-ms as the owner of this PBI workbook.

The Logic App you mention will pull Secure Score data from your subscription and store it in a Log Analytics workspace. The PBI dashboard will use this data from the LA workspace and provide graphical insights into it.

from microsoft-defender-for-cloud.

@SumeshP @amitmag-ms

I have ran into the same issue, it was caused by the double quote at beginning and end of the JSON definition. As well as the double quote in middle of the query has to be proper escaped. Plus 'rn' got inserted in end of string.

Since Tom has merged my changes. Can you test following:

1. Remove Logic App 'Get-SecureScoreData' Managed Identity from your subscription/management group role assignment
2. Remove all four resources deployed in your target Resource Group: API Connection, Azure Workboook, Logic App, Log Analytics Workspace
3. Use the new template to deploy it again
4. Assign the Logic App 'Get-SecureScoreData' Managed Identity permission to subscription or management group.
5. Manually rerun Logic App once more

Please let me know if this fixed your issue.

from microsoft-defender-for-cloud.

Hi @jyeblog I already tried removing the quotes, but it was giving me a blank workbook. Maybe there were more, i think i fixed 3 quotes maybe.
Now i have redeployed the new workbook as suggested and works!! Thanks.

from microsoft-defender-for-cloud.

Closing this issue as a solution was provided by @jyeblog.

from microsoft-defender-for-cloud.