Hi @PowerRon ,
Yes, you can check where queries containing specific keywords like %Customer% are used across multiple Power BI datasets using TMSL, MDX, or DMVs (Dynamic Management Views) in SQL Server Analysis Services (SSAS) or Power BI Premium XMLA endpoints. The most efficient way to search for references to Customer in datasets is by querying the M expressions (Power Query transformations) or dataset schema. If you're using Analysis Services or Power BI Premium, you can execute the following DMV query to search for any occurrences of Customer in dataset expressions:
SELECT *
FROM $System.DISCOVER_M_EXPRESSIONS
WHERE EXPRESSION LIKE '%Customer%'
Alternatively, if you want to check column definitions, you can run:
SELECT *
FROM $System.TMSCHEMA_COLUMNS
WHERE EXPRESSION LIKE '%Customer%'
For Power BI Premium users, you can use the XMLA endpoint to connect via SQL Server Management Studio (SSMS) and execute the above queries to identify datasets using the keyword Customer. If you're dealing with multiple Power BI datasets stored in PBIX files, you can also extract the Power Query M code by opening each file, navigating to Transform Data → Advanced Editor, and searching for Customer. Additionally, for Power BI Service (Pro or Premium), you can utilize the Power BI REST API to fetch dataset metadata and search for the query references dynamically. This approach helps ensure that you can track all dataset dependencies efficiently and update them as needed.
Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.
Connect with me on LinkedIn.
