Forum Discussion
webportal
Impactful Individual
Impactful IndividualConnect Excel table to a Power BI Service dataset
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 ...
webportalImpactful Individual
Impactful IndividualThanks, 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*])