union: column named 'TableName' already exists - Workspace Usage Report

clivewatson / KQLpublic

My useful KQL and Azure Monitor workbooks (Public)

MIT License

112 stars 50 forks source link

union: column named 'TableName' already exists - Workspace Usage Report #1

Closed VishCQG closed 4 years ago

VishCQG commented 4 years ago

The workbook use to work but now comes up with this error:

union: column named 'TableName' already exists Click to Retry.

Some parts of the workbook are still populating with data but 90% of the work book is broken. Same issue on both the Workspace Usage Report v1.3 and Workspace Usage Report v1.4 workbook error

CliveW-MSFT commented 4 years ago

Hi, Apologies, I missed this! There is a clash with the SQL solution: " SQL Data Discovery & Classification”. I'll change the name in the next release to fix this. As a workaround, edit the JSON to find & replace of 'withsource=TableName' to 'withsource=TableName1' (or any new name that is unique)