Edit query on a power bi that is in mode Direct Query

[FilipeCarv]

I have my power bi created and it is in Direct mode, but now i need to edit the query to add some more info. 

I have seen some tutorials that i could tranform it to import mode but for some reason i dont have that option. 

When i go to transform data i dont have any information at all. 

I also tried to go to model View and in the advanced > storage mode and change it but for some reason is also blocked 

Is there any way that i could edit the query ? 

Thank you 

[amitchandak]

@FilipeCarv , Are you using Direct Query on Power BI Dataset, I doubt on that you will table in Power query

[FilipeCarv]

Hi, well i created the power bi using a import setting, but  for some reason when i download the file it comes whit the setting direct query. 

Thank you for your reply !

[v-yiruan-msft · Accepted solution]

Hi @FilipeCarv ,

Thanks for reaching out to us with your problem. Base on your description, it seems that you are trying to make some transformations for the data in Power Query Editor, but you can't do it due to it is with Direct Query mode. May I know which option you chose in the below screenshot when you downloaded the pbix file from Service? If you choose the first option and you connected the data source with Import mode in Power BI Desktop, then you can performance all operations in Power Query Editor....

Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn

Best Regards