Running an Access query in PBI

[U156531]

I have created an MS Access query to filter out some records from the Access database table . I have a PBI query set up to pull in the results from the Access query.  How do I get the Access query to run from the PBI desktop?

Thanks

[lbendlin · Accepted solution]

In Access create a view with your query. In Power BI connect to that view.