Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
WiraYusoff
New Member

Update Basic Authentication Credentials with VBA Macro

Hi all,

 

Is there a way to update a data source's credentials (basic authentication) using a macro?

I would like to have a form where the user enters their username and password, and then pass the credentials to the data source. Rather than having the user click the Power Query ribbon -> Data Source Settings -> [Data Source] -> Edit -> Edit -> enter credentials -> Save -> Done -> Done.

 

I'm connecting to SAP HANA database and I need to pass the excel file to other users to run using their own credential once I'm done configuring the excel. 

 

Regards

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @WiraYusoff 

 

VBA is not supported in Power BI, if you need to restrict what users see you can use Row-level security, please see the link below.

https://docs.microsoft.com/en-us/power-bi/desktop-rls

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

1 REPLY 1
Mariusz
Community Champion
Community Champion

Hi @WiraYusoff 

 

VBA is not supported in Power BI, if you need to restrict what users see you can use Row-level security, please see the link below.

https://docs.microsoft.com/en-us/power-bi/desktop-rls

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors