I face the same problem. I created a simple parameter shown below:
I'd like this to show up as my data source in the worksheet. When I click on Auto Load, I get the same error message: Combining Direct Query & Import isn't supported. I can't change back to Import as DirectQuery is essential. Please advise.