Transform Performance Analyzer query into a new table

Question

Hello!I have a visual table that contains 15 columns coming from 4 different related tables and with different filters applied in&nbsp;my dashboard page. I want to replicate this visual table with exactly the same data shown, but in a PBI table.To do this, I went to the Performance Analyzer tab and copied the query from my visual table. However, when I go to "Create new table" and paste this query, PBI shows me errors in the code. How can I use this query to create a new table in my PBI with the same data as the visual table?This is the query for my visual table:// DAX QueryDEFINE&nbsp; &nbsp; VAR __DS0FilterTable =&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(VALUES('BL'[Source])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Source] IN {"aaa",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "bbb",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "ccc"}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; VAR __DS0FilterTable2 =&nbsp; &nbsp; &nbsp; &nbsp; TREATAS({"BotL"}, 'BL'[Type])&nbsp; &nbsp; VAR __DS0FilterTable3 =&nbsp; &nbsp; &nbsp; &nbsp; TREATAS({"TAS",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "MyProc"}, 'BL'[Local])&nbsp; &nbsp; VAR __DS0FilterTable4 =&nbsp; &nbsp; &nbsp; &nbsp; TREATAS({2024}, 'Calendar'[Year])&nbsp; &nbsp; VAR __DS0Core =&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZECOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ROLLUPADDISSUBTOTAL(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ROLLUPGROUP(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar'[MonRef],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Evo],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Local],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Source],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[PO],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Id],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[X-ID],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Name],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Status],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[O Status],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'ACR'[UB]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ), "RowTotal"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; __DS0FilterTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; __DS0FilterTable2,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; __DS0FilterTable3,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; __DS0FilterTable4,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "YTD", 'A_Measures'[YTD],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "LD", 'A_Measures'[L D],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "YTD_Dynamic_Forecast", 'A_Measures'[YTD_Dynamic_Forecast],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "SUMUB", IGNORE(CALCULATE(SUM('ACR'[%_UB])))&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; VAR __DS0PrimaryWindowed =&nbsp; &nbsp; &nbsp; &nbsp; TOPN(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 502,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; __DS0Core,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [RowTotal],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Name],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Calendar'[MonRef],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Evo],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Local],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Source],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[PO],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Id],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[X-ID],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[O Status],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'BL'[Status],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'ACR'[UB],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; )EVALUATE&nbsp; &nbsp; __DS0PrimaryWindowedORDER BY&nbsp; &nbsp; [RowTotal] DESC,&nbsp; &nbsp; 'BL'[Name],&nbsp; &nbsp; 'Calendar'[MonRef],&nbsp; &nbsp; 'BL'[Evo],&nbsp; &nbsp; 'BL'[Local],&nbsp; &nbsp; 'BL'[Source],&nbsp; &nbsp; 'BL'[PO],&nbsp; &nbsp; 'BL'[Id],&nbsp; &nbsp; 'BL'[X-ID],&nbsp; &nbsp; 'BL'[O Status],&nbsp; &nbsp; 'BL'[Status],&nbsp; &nbsp; 'ACR'[UB]

foodd · Answer

Hello&nbsp;nok, and thank you for sharing a question with the Community.&nbsp; Please&nbsp;remember to adhere to the decorum of the Community Forum when asking a question.Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216Please show the expected outcome based on the sample data you provided.https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Forum Discussion

Transform Performance Analyzer query into a new table

1 Reply

Related content

Reset Performance analyzer- For consistent duration

Performance Analyzer on Power BI Service

Performance analyzer

Performance Analyzer Doubt

Table Transformation