Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I imported one Excel-file with serveral sheets. With 3 of those sheets I did an append Query action in de Query editor. When I close and Apply the query it gives me an error "This query contains transformations that can't be used for DirectQuery". I never changed the storage mode to Direct Query. When I then go back to the editor the Appended Query give me a message that I need tot switch to een Import mode. But when I try do that, nothing happens.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.