Forum Discussion

jonclay's avatar
jonclay
Icon for Helper IV rankHelper IV
4 years ago
Solved

Select certain columns from a table within a Power BI report

Hi everyone, I have a need for users to choose which columns they select in a Power BI report, but I'm struggling to find a way to get this to work. Basically, I have a table with columns such as ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    jonclay , Yes unpivot does not work in power bi direct query. 

    My advice would be to correct the table at the source database.

     

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

jonclay , Yes unpivot does not work in power bi direct query. 

My advice would be to correct the table at the source database.