Forum Discussion

mmills2018's avatar
mmills2018
Icon for Helper IV rankHelper 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 guida...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity 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
    Icon for Helper IV rankHelper IV
    5 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
      Icon for Resident Rockstar rankResident Rockstar
      5 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

      • mmills2018's avatar
        mmills2018
        Icon for Helper IV rankHelper IV
        5 years ago

        thank-you!  Even if before sharing, I use power query to limit my data to one row of data?