"The field you are moving cannot be placed in that area of the report"

[Stacker]

So I am trying to connect a premium Power BI dataset to excel using this guide. It however is not working. When I connect the dataset using this guide, it works until I get to the pivot table option and says "The field you are moving cannot be placed in that area of the report". What do i do to connect the data to excel