Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Error in Pivot table in Excel using Power BI dataset

Hi All, 

 

I am creating a Pivot Table from Power BI dataset. On trying to pull a hierarchy, it gives an error - 

 

Is it possible to pull in hierarchies ? If not what are the alternatives. 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , If this was a direct query table used in the dataset, got to Datasource setting and check the credential has been been provided

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I tried experimenting, the hierarchies built in Power BI Dataset dont work in any case in Excel. 

      Created a table with 2 columns and nothing else in the report - 

       

       

      Is there anything that needs to be enabled 

       

      parry2k v-luwang-msft selimovd