Forum Discussion

stan_w_gifford's avatar
stan_w_gifford
Helper I
4 years ago
Solved

FIlter data on retrieve

Good morning from an extremely wet Sydney Australia.   I am developing a report where I would like to retrieve data from Dynamics (Dataverse) based on a smaller table from dataverse.   I have a t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi stan_w_gifford ,

 

I think Dataverse supports SQL query. You can add filter by SQL query like select ... from... in Advanced in Power Query Editor.

Here are some similar threads for your reference:

Pre-Filtering Data before Importing

Filetring my table before importing in PowerBi

 

Best Regards,
Rico Zhou

 

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