Solved: Filter data before import

BigLo · ‎11-18-2021

Hello,

In a report I import 3 json files that I'm not owner.
In my power query I import all the data then I filter on a field using a parameter. With to this filter I drop 90% of the data.
Wouldn't it be possible (and cleaner) to be able to filter before importing and only load the data that interests me?

Anonymous · ‎11-24-2021

Hi @BigLo ,

Unfortunately, currently Jason files cannot be filtered before being imported. Like SQL Server, you can enter the query statement in the following SQL statement before importing to achieve pre-filtering.

You can import Jason files into SQL server, and then Power BI connects to SQL server to implement pre-filtering.

Best Regards,

Stephen Tao

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

View solution in original post

Anonymous · ‎11-24-2021

Hi @BigLo ,

Unfortunately, currently Jason files cannot be filtered before being imported. Like SQL Server, you can enter the query statement in the following SQL statement before importing to achieve pre-filtering.

You can import Jason files into SQL server, and then Power BI connects to SQL server to implement pre-filtering.

Best Regards,

Stephen Tao

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

KNP · ‎11-18-2021

How do you expect us to answer that? Yes?

Show us your query code at least so we can offer some suggestions.

Is the filter step the first thing done after the connection to the source files?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr