The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
128 | |
119 | |
82 | |
78 |