Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Please fix this.
Thanks,
Dan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.