Forum Discussion

KH11NDR's avatar
KH11NDR
Helper IV
7 years ago

Unpivot only selected columns not working

Hi Guys,   I'm editing a query (table) which I've loded in from SQL and it allows me to Unpivot only selected columns and I'll rename the two columns as date and values.  But when i press close and...
Need Help
KH11NDR's avatar
KH11NDR
Helper IV
7 years ago

Are you using the data via SQL or Excel? can you share your Power BI file?

 

Thanks

 

I think mine might be a data type issue.

KH11NDR's avatar
KH11NDR
Helper IV
7 years ago

Reloaded the data and worked fine.................................Friday gremlings.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    KH11NDR,

     

    Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.

  • KH11NDR's avatar
    KH11NDR
    Helper IV
    7 years ago

    v-chuncz-msft

     

    I haven't accepted a solution because there wasn't a solution given.  I understand PattemManohar has been very helpful, but that wasn't the soloution as I already know how to pivot the table how I wanted it, My problem was the data wasn't loading with the pivoted columns, so it would be wrong for me to say that was the soloution when it wasn't and save people from trying it.  But for PattemManohar great help, i have given  PattemManohar a tick for thanks.

     

    I hope you understand my reasons for not accepting a solution.

     

    My solution was to reload the data from scratch and it worked.