Solved: Re: Transform data not enabled

anoomohan · ‎04-04-2022

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

v-easonf-msft · ‎04-07-2022

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

View solution in original post

Pragati11 · ‎04-04-2022

HI @anoomohan ,

Can you share some screenshots on this please?

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

Best Regards,

Pragati Jain

LinkedIn | Twitter | Blog | YouTube

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

anoomohan · ‎04-04-2022

I imported pbix file from powerbi dataset

v-easonf-msft · ‎04-07-2022

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

Shreeya · ‎03-08-2023

Has this solution worked for anyone? The 'Transform data' is still greyed out for me.

Trish53 · ‎09-26-2023

Hi there,

Even if I enabled the option "DirectQuery for Power BI datasets and Analysis Services", the option "transform data" is still greyed out for me as shown.

Help please!

Anonymous · ‎02-25-2023

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

HugoFrauches · ‎03-27-2023

Hello,

I have the same issue, you are able to resolve this problem?

YanTseng · ‎12-03-2022

I am trying to import an excel file. I tried the Options-> Preview Features ->DirectQuery for PBI datasheets and AS.

The Load and Transform data still grayed out.

Scriptx1 · ‎02-10-2023

Same here. I haven't found a solution yet for this one.

anoomohan · ‎04-07-2022

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 · ‎04-07-2022

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