Using Direct Query and filtering on a column

Hi Berl21 ,

It sounds like you are trying to use a date parameter in Power Query while working in Direct Query mode, but encountering an error message that Direct Query does not support the step you are trying to make.

One possible solution is to switch to Import mode, as suggested by the error message. In Import mode, you can use date parameters in Power Query without encountering the same limitations as Direct Query mode.

If you need to continue working in Direct Query mode, you may need to explore other options for filtering and manipulating your data that are supported in Direct Query mode. One option is to use SQL code to filter your data before loading it into Power Query. Another option is to use Power BI's built-in query editor to filter and manipulate your data in ways that are supported in Direct Query mode.

Refer to:

DirectQuery in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.