Forum Discussion

anoomohan's avatar
anoomohan
Helper III
4 years ago
Solved

Transform data not enabled

Hello everyone,

 

Transform data is not enabled in my powerbi desktop - while I have proper acess to the dataset and I imported the pbix file from Power Bi service

 

Please help 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, anoomohan 

    This is normal. Your data model comes from the PowerBI Service. You are using a live connection method for the dataset. So the ‘Transform Data’ option is greyed out.

     

    As a workaround, you can enable the option 'Directquery for PBI datasets and AS' and restart PowerBI Desktop.

     When you revisit the PBI dataset, this ‘Transform Data’ option will be available.

     

    Best Regards,
    Community Support Team _ Eason

12 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI anoomohan ,

     

    Can you share some screenshots on this please?

    Are you using a live connection or DirectQuery method for the dataset?

     

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, anoomohan 

        This is normal. Your data model comes from the PowerBI Service. You are using a live connection method for the dataset. So the ‘Transform Data’ option is greyed out.

         

        As a workaround, you can enable the option 'Directquery for PBI datasets and AS' and restart PowerBI Desktop.

         When you revisit the PBI dataset, this ‘Transform Data’ option will be available.

         

        Best Regards,
        Community Support Team _ Eason