Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys!
I am new to PowerBI and my company needs to know few things for sure before we can start publishing reports. I am using DirectQuery to query my database and bring few tables from SQL database. Due to sensitivity of data, I want to avoid bringing few columns into PowerBI.
The option I see as a easy fix: bring tables in and then delete columns that I do not require. For this option, I want to know if - using DirectQuery/Import function I bring entire table in and delete few sensitive columns, will that result in PowerBI not bringing those columns into its environment in anyway. And if I publish these reports, am I 100% sure those deleted columns wont get published in anyway? Specially, in-case of Import function.
Other easy fix: write custom SQL for bring in tables.
Which would be the best suggested option considering the sensitivity of data?
Thanks for your help!!
Best,
Rahul Dhamnani
Solved! Go to Solution.
Hi @rahul_dhamnani,
Just for some expand of smoupre's point, in "direct query" mode, you can also use "Table.SelectColumns" function to hide the sensitive columns.
Add a custom steps and use table.selectcolumns to choose the displayed columns.
Reference:
Regards,
Xiaoxin Sheng
Hi @rahul_dhamnani,
Just for some expand of smoupre's point, in "direct query" mode, you can also use "Table.SelectColumns" function to hide the sensitive columns.
Add a custom steps and use table.selectcolumns to choose the displayed columns.
Reference:
Regards,
Xiaoxin Sheng
If you use Import, you can remove the columns as part of the Power Query and they will not be imported into the model. In DirectQuery, you would have to write SQL.
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |