Connect Excel table to a Power BI Service dataset

[webportal]

I have an Excel file connected to a Power BI dataset with a Pivot Table.

All is fine, but the Pivot isn't what I need. I'd like to get a Table instead.

So, clicking on the grand total of the Pivot returns the Table, as expected.

But some fields are missing (Date, for example).

How can I edit the query statement of the table to return these fields?

Currently it is:

DRILLTHROUGH MAXROWS 1000 SELECT FROM [Model] WHERE ([Measures].[Measure*])

[webportal]

@v-jingzhang 

Thanks, I mention that in my question.

The table has some fields missing (Date, for example).

How can I edit the query statement of the table to return these fields?

Currently it is:

DRILLTHROUGH MAXROWS 1000 SELECT FROM [Model] WHERE ([Measures].[Measure*])

[v-jingzhang]

Hi @webportal 

Since you have connected to a Power BI dataset in Excel, you can use the fields to create a brand new pivot table per your need if you are not satisfied with the current pivot table. 

If you only want to keep the data from a pivot table, you could refer to below video to convert a pivot table to a standard table.

How to Convert a Pivot Table to a Standard List or a Table - YouTube

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.