topic PowerBI Embedded with parameters for a 3rd party authentication in Developer

PowerBI Embedded with parameters for a 3rd party authentication

Red217 — Wed, 22 Sep 2021 17:03:06 GMT

Hello,

i currently use PowerBI and one of my DataSource is a 3rd Party tool that I connect with via a "json.document(web.contents)"

i have set "powerBi parameters" for "username" & "password" to be used in a way that the user can input them themselves (the same report can be used in different workspaces by a different users and they need a different username & password for the 3rd party )

these parameters are used in my Queries ( an oauth2 process)

Now to my question, I am thinking about embedding this PowerBI report / Dashboard into a Web App , but in this case I will need to provide a DIFFERENT Username & Password and then REFRESH the Dataset for each login ( because each username & password will get you other info from the 3rd party ).

1. is it even possible to "passthrough" BI Credentials for a dataset like that ?

2. if not , how do you recommend approaching it ?

Re: PowerBI Embedded with parameters for a 3rd party authentication

Anonymous — Mon, 27 Sep 2021 06:08:52 GMT

Hi Red217

If you can use parameter to connect to 3rd party data source successfully in Power BI Service, I think you just need to configure Power BI Embedded correctly, then you can use this function as well in Power BI Embedded.

There are two kinds of Power BI Embedded.

One is embed for organization, this way need your end user have Power BI account in your organization. Each time your end user need to login in their Power BI account if they want to see Power BI Embedded report in your Web portal.

For reference: Embed Power BI content using a sample embed for your organization application

Another is embed for customer, by this way, your end user doesn't need to be a Power BI user, they doesn't need to authenticate.

For reference: Tutorial: Embed Power BI content using a sample embed for your customers application

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: PowerBI Embedded with parameters for a 3rd party authentication

Red217 — Mon, 27 Sep 2021 18:37:52 GMT

Thanks, Rico,

my point is that our parameters are different for each user for that 3rd party tool,

so we will need a way for us to "pass them through" dynamically and not via the "settings" in Dataset, is it possible ?