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

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

anoomohan's avatar
anoomohan
Helper III
4 years ago

Thank you - yes that works! 

 

If I transform the data model with direct query now, will it affect the data for other users in power bi service?

 

sorry if it's a very basic question, I am yet to take a course for the desktop, but need some help to get few reports urgently before I take the course

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

    Hi, anoomohan 

    No,you are just send queries via PowerBI Desktop to get the data so it does not involve any data changes to the underlying data source. It will not affect the data for other users in Power BI Service.

     

    Best Regards,
    Community Support Team _ Eason