Delete tablename in Powerbi layout definition of a report with live connection to a dataset.

[CBO2404]

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. (I think it was a visual filter on a year in the past.)

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"
}

[CBO2404]

Thanks for your response. I saw this as well, but I had hoped there would be a cleaning tool. However, as I understand it, this has to be done manually.

[MFelix · Accepted solution]

Hi @CBO2404 ,

The definition of the fields are different from visualization to visualization and also depending  where you are using it, believe the best option is to save your model has a PBIP format and then using visual studio code you can check inside the folder where that specific table is being used and delete those occurrances.

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview

The new PBIP format savbes each of your pages and visualizations in specific files making it easier to work in a batch manner, and the format is much more readable than the Json Format.