Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
@FilipeCarv , Are you using Direct Query on Power BI Dataset, I doubt on that you will table in Power query
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 !
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
119 | |
104 | |
77 | |
69 |