How a summarized table that created by DAX formula in Data pan can be seen/imported in query editor

[myti]

Dear Friends,

I have faced a problem in PBI.is there any soloution that a summarized table created by DAX formula bring in query editor.Seems that only the source tables can be seen in query editor?

Thank you,

Medi

[v-ljerr-msft]

@myti

Not like tables(queries) created in Query Editor can be shown and referenced in Data View of Power BI Desktop, the calculated tables created in Data View using DAX can only be used within Data View.

In this scenario, you may need to rebuild that table in Query Editor using M Query. Here is a similar thread for your reference.

Regards

[BhaveshPatel]

Hi Medi,

You should download the DAX Studio. Connect Your PBI File with DAX Studio and Run your DAX Query againest the Model and set the output to the Text File. This File will have your Summerized table Data and You can ETL with this data into the PBI. 

[Greg_Deckler]

Correct. You would have to create a new query and do your summarize in the query editor instead.