I have a Power BI report with a live connection to a dataset. My Power BI PBIX file contains a (reference to a) table, but that table no longer exists in my dataset. In the desktop application, I can’t find it anywhere except in the layout JSON file. It appears approximately 90 times.
How can I remove all occurrences at once? It is present in multiple visual definitions. This is one of the sections in JSON:
"selector": {
"data": [
{
"scopeId": {
"Comparison": {
"ComparisonKind": 0,
"Left": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Unused Table"
}
},
"Property": "reverse"
}
},
"Right": {
"Literal": {
"Value": "'aug2023'"
}
}
}
}
}
],
"metadata": "_Measures.CalculateSUM"
}