Forum Discussion

mmills2018's avatar
mmills2018
Helper IV
5 years ago

Power Query

I want to use power query to subset my data to a specific employee.  any ideas of how i can do this.  I understand it depends on the name of my file, etc, but are you able to provide high level guidance?

Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    mmills2018 , The information you have provided is not making the problem clear to me. Can you please explain with an example.

     

    You can use parameter or Dynamic M parameters 


    Appreciate your Kudos.


    • mmills2018's avatar
      mmills2018
      Helper IV
      5 years ago

      yes, i am sorry.  I have a massive data file, serval 1000s rows of data.  I want to filter by data to just one employee id.  i want to do this through power qi and delete the other rows of data. tyring to see if this is a possibility?

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi mmills2018 ,

     

    Do you mean to pass user logged-in information to Power Query to filter the data before being imported into Power BI according to the logged-in user, instead of filtering data, such as RLS, slicer, after all the data being imported?

     

    In adition, what's your data source? And is the connection type import?

     

     

    Best Regards,

    Icey

    • mmills2018's avatar
      mmills2018
      Helper IV
      4 years ago

      for my data source is an intergration feed.  All my data is in PBI, now what i want to do is filter my million plus rows to one Employee by their employee id using Power Query.  Is this possible?  I am trying to give someone else my pbix without the sensitive data in the pbix.  I can't completely remove the data, hence why i want to only include one row of data.  Also, if i pass off this pbix to another person, would they be able to use power query to reverse essentially the only 1 row of data?

      • Burningsuit's avatar
        Burningsuit
        Resident Rockstar
        4 years ago

        If you share a PBIX with someone, they will allways have full access to all the data in that PBIX. They may also be able to view all source data and undo any filtering in Power BI. For this reason, it's better to publish the report to Power BI and share that with them, which is secure. If you use Row Level Security you can secure the published Dataset by login, so what can be seen of the data depends on Power BI login details.

        Generally there is no security if you share a pbix file, security can be applied once the data is  published to Power BI service.

         

        Hope this helps

         

        Stuart