Forum Discussion

BigLo's avatar
BigLo
Icon for Helper III rankHelper III
4 years ago
Solved

Filter data before import

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. Woul...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.