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

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?

 

  • anoomohan's avatar
    anoomohan
    Helper III
    4 years ago

  • anoomohan's avatar
    anoomohan
    Helper III
    4 years ago

    I imported pbix file from powerbi 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        The Buttom appeared, but when I click does not bring me any tables to Edity