The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
I have a problem with the switch from direct Query mode to import mode, I have to qualify fo conditions like "no space" , or "no duplicates" but when I want to delete the duplicates or the spaces in my table it says it can't be done in direct Query mode. So I can't have the conditions to switch to Import mode because I'm the direct Query mode. So I don't know how to do.
Remove all relations > import your data > and then set relations
______________________________________________________
If you found this post helpful, please give Kudos C
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.