We have created and published PowerBI datasets - connected via DirectQuery to on-prem SQL Server database.
We have users who would like to access these PBI datasets via Excel. We have installed the add-in and users can view all fields.
The problem is -- when trying to create a pivot table -- the numerical fields are not recognized. So, cannot drag # fields into pivot table. Those fields appear to be intrepreted as text fields so get the error: 'The field you are moving cannot be placed in that area of the report.' All text fields (and dates) seem to work fine.
The only way to make this work is to recreate the numerical fields as measures. But, we have literally hundred of fields -- so are not going to do that.