Solved: Python Piovt Query Output is not giving index valu...

Anonymous · ‎12-13-2019

I tried pivot table in Power BI using python script but the output i am getting is something different than what I am getting in python independently. I want first colum but Power Bi skipping that colum and giving result.

v-lid-msft · ‎12-15-2019

Hi @Anonymous ,

We can use M query in Power Query Editor to pivot tables

If Power Query Editor does not meet your requirement, could you please share the name of python indenpendy you used to pivot table if it does not contain any confidential information?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-lid-msft · ‎12-29-2019

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lid-msft · ‎12-15-2019

Hi @Anonymous ,

We can use M query in Power Query Editor to pivot tables

If Power Query Editor does not meet your requirement, could you please share the name of python indenpendy you used to pivot table if it does not contain any confidential information?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.