Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

PBI report service failure: Pivot Table

Hi Team,

 

Issue:

I'm facing data source error while refreshing the report in service

Error :  The 'XYZ' column does not exist in the rowset. Table: ABC

My ABC table is the duplicate of it's source table and has pivoted columns.

However, the report refreshes fine in desktop.

 

Please help urgent.

Thanks

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    Thanks for the reply from lbendlin .

     

    I created a simple sample data and it worked fine:

    Type

    Value

    A

    10

    B

    20

    A

    30

    B

    40

    A

    50

    B

    60

     

    After pivot:

    A

    B

    90

    120

     

    The visuals can be refreshed and viewed normally in the Service before and after pivoting.

     

    Please try downloading the latest version of Power BI Desktop, re-create the pivot table in Power BI Desktop, republish the dataset to the Power BI service, and then try refreshing it.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Power BI Service cannot handle dynamic data sources. You will likely need to refrain from pivoting in Power Query and instead do it in the User Interface (with a matrix visual)

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    Thanks for the reply from lbendlin .

     

    I created a simple sample data and it worked fine:

    Type

    Value

    A

    10

    B

    20

    A

    30

    B

    40

    A

    50

    B

    60

     

    After pivot:

    A

    B

    90

    120

     

    The visuals can be refreshed and viewed normally in the Service before and after pivoting.

     

    Please try downloading the latest version of Power BI Desktop, re-create the pivot table in Power BI Desktop, republish the dataset to the Power BI service, and then try refreshing it.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!