I have a similar problem but I need a solution that allows me to find this information on many Power BI reports at the same time.
This is the use case:
We have about 50 Power BI reports using multiple datasets. Most of them where built using SQL queries pulling data from a MS SQL server. IT advised us there will be a change in one of the systems which will affect how we are calling some of the tables we are using. So we need to know which Power BI dashboards will be impacted.
I know I can open one by one and verify but there has to be a more efficient way. I know the PBIX files are zip files and the mqueries are in there, but how can I search thorugh all the 50 pbix files automatically?