
Concluído
Publicado
Pago na entrega
I need a small, end-to-end proof of concept that links a Snowflake dataset to a Power BI report and then restricts what each persona can see once the report is published. Scope • Build a simple Employee table in Snowflake with First Name, Last Name, Date of Birth and Salary. • Design the Snowflake roles and grants from scratch (none exist yet) so that one persona can see every column while another sees everything except Salary. • Connect Power BI to Snowflake, import that table and create a single tabular page that lists the data. • Configure column-level security (or equivalent) so: – User A sees all four columns. – User B sees all except Salary. The solution must work when the report is shared through the Power BI Service, ideally by mapping the Snowflake roles to our Active Directory groups, but I’m open to other proven methods if that is cleaner. Deliverables 1. Snowflake SQL script: table DDL, role creation, grants. 2. Power BI (.pbix) file with the security rules in place. 3. Step-by-step notes or a short loom/written walkthrough explaining how to recreate the setup and how to add more personas later. Acceptance criteria: logging in with two test accounts clearly demonstrates the difference in column visibility, with no back-door access to Salary for the restricted user. Use whatever tooling you prefer—Snowflake worksheets, Power BI Desktop, Azure AD—just keep it reproducible and clean.
ID do Projeto: 40396289
24 propostas
Projeto remoto
Ativo há 10 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

This is exactly the kind of work I handle well. Setting up Snowflake roles with precise grants and building a clean Employee table is straightforward, especially ensuring that column-level restrictions are enforced during Power BI imports. It's important to manage role-to-AD group mapping carefully to avoid any gaps in security. I will document the process clearly to ensure each step from the SQL scripts to Power BI security settings is easy to follow and extend. This approach keeps deployment smooth and user access cleanly separated. Reach out for a free consultation, I am happy to offer honest advice either way. Stef
$100 CAD em 14 dias
0,0
0,0
24 freelancers estão ofertando em média $131 CAD for esse trabalho

I ALREADY MADE SIMILAR PROJECT LIKE THAT BEFORE. I can start working immediately on "Power BI Snowflake Access Control" ,, I will deliver a fully dynamic solution that meets all your requirements efficiently and with high accuracy. About me: 10+ years Advanced Excel/data visualization experience, Certified VBA Programmer, MBA.
$125 CAD em 1 dia
4,8
4,8

Hi, I have 9 years experience in Snowflake, SQL, Power BI, Active Directory, and secure data modeling. For this project, I will build the Snowflake table and role-based access model, connect it to Power BI, and implement column-level security so visibility differs correctly per persona when published to Power BI Service. You can expect clear communication, fast turnaround, and a high-quality result. I’ve implemented similar role-based and column-level security setups and will provide clean SQL scripts, a ready .pbix file, and a simple walkthrough to extend the setup. Best regards, Juan
$125 CAD em 1 dia
3,5
3,5

Hi, Sahanaj here. I’ve built Snowflake + Power BI security setups (roles, masking/column security, AD mapping). I’ll create the Snowflake DDL + roles/grants, implement column-level restriction (secure views/masking), connect Power BI, and validate persona-based access in Service—clean and reproducible. Proposed: $250–$350 CAD fixed, 1–2 days (incl. testing + walkthrough). I’ll ensure no leakage via direct queries. Question: Are you using Azure AD for Power BI access, or local/test users for this POC?
$250 CAD em 2 dias
2,9
2,9

Dear Client, I am ready to deliver the end-to-end proof of concept for Power BI + Snowflake column-level access control exactly as specified. I will: Create the Employee table in Snowflake (First Name, Last Name, Date of Birth, Salary) Design roles and grants from scratch: one persona sees all columns, another sees everything except Salary (using secure views or dynamic column masking) Connect Power BI Desktop to Snowflake and build the simple tabular report Configure security so User A sees all 4 columns and User B sees only 3 when published to Power BI Service Map Snowflake roles to Azure AD groups (or provide the cleanest alternative if preferred) Deliverables: Complete Snowflake SQL script (table DDL + roles + grants) Fully configured .pbix file Step-by-step walkthrough (written + Loom if needed) showing how to recreate and extend for more personas The solution will be clean, reproducible, and enforce security at the Snowflake level. Ready to start immediately upon award.
$125 CAD em 5 dias
3,0
3,0

As a seasoned full-stack engineer with over 6 years of experience, I am confident in my ability to deliver on your Power BI Snowflake Access Control project. Throughout my career, I have developed a robust skill set in Power BI and SQL, which are essential for this task. I understand the importance of clean and maintainable architecture, especially when it comes to something as critical as data security and access control. Given this, I can assure you that the solutions I'll provide will not only be precise but also easily replicable. I am particularly interested in your requirement regarding reproducibility and cleanliness. With my proficiency in data pipelines, analytics, and ML components, I can ensure an end-to-end process that aligns with your needs. Furthermore, my experience in automated workflows will be an added advantage as it allows me to expedite processes while reduce any margin for error. I take great pride in approaching problems holistically and collaboratively. My commitment is to provide you with solutions that not only accomplish the baseline functionality but also exceed your expectations. Let's work together to transform this proof of concept into a foundational solution for your operations and optimize your data management capabilities.
$125 CAD em 7 dias
2,4
2,4

I can build this Snowflake-Power BI access control proof of concept efficiently. I'll start by creating the Employee table in Snowflake with the four specified columns, then design a role-based security model using Snowflake's RBAC system where I'll create two custom roles - one with full table access and another with a view that excludes the Salary column using column masking or row access policies. For the Power BI integration, I'll establish the connection using Snowflake's native connector, import the table and design a clean tabular report layout. The critical part is implementing the role mapping between Snowflake users and Power BI Service users through proper authentication flow, likely using SSO or direct user mapping in the Power BI gateway configuration. I'll ensure the column-level security persists when the report is published to Power BI Service by leveraging Snowflake's dynamic data masking combined with Power BI's RLS (Row Level Security) if needed. The key technical nuance most developers miss is that the security model must be enforced at the Snowflake level rather than Power BI level to ensure data never leaves Snowflake unauthorized, which requires careful configuration of the connection string and authentication method.
$140 CAD em 3 dias
0,3
0,3

Hello, With over a decade of experience designing and developing end-to-end SaaS platforms, I'm uniquely positioned to help you realize your vision for this Power BI Snowflake Access Control project. I have a deep understanding of data visualization, having shipped numerous production systems in fields like collaboration and analytics. Moreover, I specialize in creating robust and scalable architectures without accumulating technical debt. One powerful aspect of my skill set is my expertise in creating real-time and interactive systems. This project of yours requires not only connecting Power BI to Snowflake but also implementing column-level security that works seamlessly when the report is shared through the Power BI Service. My proficiency with WebSockets, Redis Pub/Sub, and offline-resilient architectures will come into play here. Lastly, I'm a proponent of clear communication and documentation throughout the development process. From architectural diagrams to realistic timelines and from CI/CD to production handoff docs, I prioritize transparency at every step. With my help, your POC would be solidly built using your preferred tools while adhering to reproducibility and clean standards. Let's get started on this project and deliver above your expectations! Thanks!
$100 CAD em 3 dias
0,0
0,0

With my decade-long experience in providing end-to-end digital solutions, I believe I am the perfect fit for your Power BI Snowflake Access Control project. My expertise in data engineering and visualization is evident by my proficiency in tools like Snowflake, Power BI, and SQL. I can build Snowflake roles and grants from scratch, design reproducible security rules within Power BI, and empower your personas with the access control they need. Talking about security, the focus is on building robust systems that not only restrict access but also provides auditability. I can map your Snowflake roles to Active Directory groups or follow a proven method according to your preference while ensuring no back-door access to restricted data for any user. Efficiency, scalability, and security are my watchwords when it comes to handling data, just as you have mentioned in your scope. Lastly, I'm capable of offering detailed step-by-step notes or even a loom/written walkthrough on how to recreate the setup and add more personas later on. As a team player focused on your satisfaction, I assure you that your project will be delivered to exceed expectations. Sounds great? Let's bring your Digital Dreams into Reality!
$125 CAD em 7 dias
0,0
0,0

This is exactly the kind of work I love doing, and I'm currently offering premium quality at a reduced rate while building my reputation — meaning you get full dedication without the full price tag. I understand you need a solution for linking and controlling access to a Snowflake dataset for Power BI reporting. You're specifically aiming for column-level security. This is crucial to ensure different personas have accurate access permissions, which would be met through detailed role setups and linkage to Active Directory. I have extensive experience in SQL, Business Intelligence, and Data Visualization, aligned perfectly with the project demands of designing Snowflake roles and Power BI integration. I guarantee high-quality results and am happy to provide insights even if I'm not selected. Looking forward to potentially collaborating. Regards, Jason McLachlan
$114 CAD em 3 dias
0,0
0,0

Hello, With my expertise in Snowflake data engineering and Power BI security modelling, I can build a clean end-to-end proof of concept that demonstrates secure, role-based data access from Snowflake through to Power BI Service. I will create a structured Employee dataset in Snowflake along with a role and grants architecture designed from the ground up, ensuring one persona has full visibility while another is restricted from sensitive fields such as Salary. Using Snowflake roles mapped to Azure Active Directory groups (or an equivalent secure identity approach), I will implement column-level security and validate enforcement directly in Power BI. The report will include a simple, clear tabular view published to Power BI Service, demonstrating real-world access differences between User A and User B. Deliverables will include Snowflake SQL scripts, a fully configured PBIX file, and concise setup documentation so you can easily replicate and extend the model for additional personas later. Thanks!
$150 CAD em 2 dias
0,0
0,0

Hi, Graycell America is new on Freelancer and we are operational since 2002. Yes we can surly deliver your requirement with our expert Certified Power BI Resource, I would like to discuss it on DM or Call at Freelancer. We want to increase our presence in Freelancer and we have globally enterprise level experienced certified Power BI & Data Analyst expert in our team. You won't we disappointed. Lets join in DM and discuss.
$150 CAD em 7 dias
0,0
0,0

Hello, I am Darko, I have extensive experience integrating Snowflake datasets with Power BI while implementing robust role-based access controls. For your project, I will create a simple Employee table in Snowflake, define roles and grants so that one persona can view all columns while another cannot see Salary, and connect Power BI to import the table into a single tabular page. Column-level security (or equivalent) will be configured so User A sees all columns and User B sees all except Salary, and the setup will remain secure when shared through Power BI Service. A clear, step-by-step guide will show how to recreate the setup and add more personas in the future. Let's discuss!
$150 CAD em 4 dias
0,0
0,0

I am the data engineer from Microsoft, I can deliver all scope of the work you need, and can describe the project with real world examples and usecase.
$100 CAD em 1 dia
0,0
0,0

Hello I understand you need a Proof of Concept integrating Snowflake with Power BI, with role-based and column-level security between two personas. I have solid experience with Snowflake RBAC and Power BI security implementation, and I can build a clean, reproducible setup that enforces strict data access rules. What I will deliver Snowflake SQL script (table + roles + grants + security setup) Power BI (.pbix) connected to Snowflake with working report Security configured so: User A sees all columns User B cannot access Salary (fully restricted, not just hidden) Step-by-step notes for setup and adding new users Why me Strong experience in Snowflake + Power BI integration Proper implementation of secure role-based access Focus on clean, testable Proof of Concept I can start immediately and deliver a fully working and verifiable solution.
$100 CAD em 5 dias
0,0
0,0

Hi, I can build this end-to-end Snowflake → Power BI proof of concept with clean, secure role-based access. I’ll create the Employee table, design Snowflake roles (full vs restricted), and apply precise grants so Salary is fully protected. In Power BI, I’ll connect, model the data, and implement column-level security (via Snowflake roles or RLS workaround) ensuring User A and User B see different columns even after publishing. You’ll receive: • Complete SQL scripts • Ready-to-use .pbix file • Clear step-by-step setup guide (plus how to add new personas) The solution will be tested with two accounts to guarantee no Salary exposure. Let’s get started. ROHIT
$125 CAD em 7 dias
0,0
0,0

Hello, I have experience with Snowflake role-based access control and Power BI integration, having built data governance solutions with column masking policies and RLS implementations. For your POC, I can create the Employee table with Snowflake roles using column-level security through masking policies, then connect Power BI via the Snowflake connector and configure workspace roles mapped to your AD groups. One approach is using dynamic data masking in Snowflake rather than Power BI RLS for cleaner role inheritance. Let's discuss!
$150 CAD em 3 dias
0,0
0,0

Hi, I’ve built similar Snowflake + Power BI setups where sensitive data like Salary is fully hidden per user role. I’m Matthew, a Software Engineer, and I can create your full PoC with secure roles, Power BI report, and clear step-by-step setup. I will design Snowflake roles, use secure views for column control, connect Power BI, and ensure it works correctly in Power BI Service. I recently did a project where different users saw different financial data with no leakage. Do you prefer using Azure AD groups for mapping users, or should I set up a simple role-based demo first?
$100 CAD em 7 dias
0,0
0,0

Hello. I set up Snowflake roles and Power BI column-level security with AD group mapping. Quick example. A client needed salary hidden from managers. I created two roles, assigned grants, and linked to Power BI. Row visibility worked instantly. For your PoC, I will build Employee table, define roles, connect Power BI, and enforce column security so User A sees all, User B sees no salary. Works in Power BI Service. Timeline: done in 2 days. What you get is a reusable security model. What about having a chat for more detail? Thanks.
$130 CAD em 2 dias
0,0
0,0

Hi there, I am interested in this project. I have solid experience with Snowflake security configurations, including role-based access control and masking policies, as well as implementing Row-Level and Column-Level Security within Power BI. I can provide the SQL scripts for the Snowflake setup, the configured .pbix file, and a clear, step-by-step documentation guide to ensure you can easily manage and expand this setup in the future. I am ready to start immediately and can have this proof of concept ready for you quickly. Looking forward to discussing this further. Best regards,
$150 CAD em 1 dia
0,0
0,0

I read your PoC requirements carefully. Unlike the generic template bids you're getting, I actually understand the Snowflake-to-Power BI security bridge you need. To hide the 'Salary' column for User B, standard row-level security (RLS) won't work. We need either Power BI Object-Level Security (OLS) or Snowflake's Dynamic Data Masking. Here is my exact plan for your PoC: Snowflake: Write clean DDL for the Employee table and set up the two roles (Admin vs Restricted) with proper grants from scratch. Power BI: Connect the dataset and enforce the column-level security so User B literally cannot see or query the Salary column. Handover: I will record the exact Loom video you asked for, logging in with both test accounts side-by-side to prove the security holds up perfectly with no backdoors. I'm a Computer Engineering & AI student, so my SQL scripts and data models are strictly structured and clean. I can start on this today and have the .pbix and SQL scripts ready for you quickly. Let's chat so we can get this done. Best, Rahma
$125 CAD em 3 dias
0,0
0,0

Blainville, Canada
Método de pagamento verificado
Membro desde set. 28, 2004
$30-50 USD
$30-250 CAD
£250-750 GBP
$250-750 USD
₹600-1500 INR
£20-250 GBP
₹75000-150000 INR
$30-250 USD
$30-250 USD
$250-750 USD
$30-250 USD
₹750-1250 INR / hora
$25-50 USD / hora
₹37500-75000 INR
£250-750 GBP
£20-250 GBP
$10-30 USD
₹750-1250 INR / hora
$250-750 USD
$250-750 USD
₹12500-37500 INR
$5000-10000 USD