topic Re: Secure write back possible in custom visual? in Developer

Secure write back possible in custom visual?

PowerbiStarter — Sat, 30 Jun 2018 08:00:27 GMT

Hi PowerBI community,

I have a question:
- Is it possible to -in a secure way- implement write back functionality in PowerBI using custom visuals?
- if so, how?
- if not, please explain what the blocking piece is

Details
- please note that I have already a working .pbiviz that does write back functionality (it can call an external api using jQuery). I have verified that I was able to post datapoints from powerbi to this api that is hosted on a different server

Only question is security related
- Now this external api is “open”: no authentication required
- My question is if (and how) I can authenticate myself against this external api so only authenticated users in PowerBI can call the apu

Use case
- we have a clients that have this requirement, and are flexible in how to exactly organize this

Please let me know what is (or is not) possible

Thanks!

Re: Secure write back possible in custom visual?

v-viig — Mon, 02 Jul 2018 10:01:35 GMT

Power BI CV API does not provide authentication mechanism so far.
We'd recommend to implement your own authentication that will ask user to log in.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Secure write back possible in custom visual?

PowerbiStarter — Mon, 02 Jul 2018 14:22:02 GMT

Thanks for the reply.

It is not the answer I hoped for (user-experience-wize), but it is clear at least.

Also I hope this will soon be implemented; in Qlik and some other data visualization tools you have ways to do this, and I see these kinds of requests more and more...

Re: Secure write back possible in custom visual?

v-viig — Tue, 03 Jul 2018 09:46:59 GMT

Authentication is on backlog. It'll be considered soon.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Secure write back possible in custom visual?

PowerbiStarter — Tue, 03 Jul 2018 15:53:08 GMT

Super; thats good news. Thanks for the quick reply again!

Re: Secure write back possible in custom visual?

nivasnalla — Mon, 13 Aug 2018 04:31:18 GMT

If possible, could you please share the code snippet used to call the external API. I am finding hard to make it work.

Re: Secure write back possible in custom visual?

v-viig — Mon, 13 Aug 2018 11:51:57 GMT

You just need to produce an AJAX call to remote server via request, jquery, or other libraries.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Secure write back possible in custom visual?

nivasnalla — Tue, 14 Aug 2018 00:00:50 GMT

// inside the custom visual contructr

document.body.innerHTML = '<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>'
+'<input id="txtname" type="text" /></p>'
+'<input id="InsertRecord" type="button" value="Insert"></input>'

let bttnClick = document.getElementById("InsertRecord");
bttnClick.addEventListener("click", (e: Event) => this.getCall());

// out side the constructor and inside the visual class

getCall(){

$(function() {
$.getJSON("https://api.ipify.org?format=jsonp&callback=?",
function(json) {
document.write("My public IP address is: ", json.ip);
console.log(json.ip)
}
);
});
}

I used the above to call an web api that returns the public IP to console and I am getting the below error

API Reference : https://www.ipify.org/

Uncaught TypeError: $ is not a function
at Visual.getCall (<anonymous>:627:25)
at HTMLInputElement.<anonymous> (<anonymous>:614:89)

I might be missing jquery reference somewhere, but I couldn't figure it out. Any help would be greatly appreciated, thanks in advance.

Re: Secure write back possible in custom visual?

v-viig — Tue, 14 Aug 2018 12:18:37 GMT

Please follow this guide to import jQuery into your custom visual. You just need to replace d3 into jQuery wiht a proper version.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Secure write back possible in custom visual?

Anonymous — Tue, 20 Nov 2018 09:32:39 GMT

Is there any update regarding the Authentication?
We have the same client requirement - How can I authenticate myself against this external API so only authenticated users in PowerBI can call the API.

Re: Secure write back possible in custom visual?

v-viig — Wed, 21 Nov 2018 07:15:24 GMT

Auth API for Microsoft Services is in progress. No particular ETA yet.

For external services you should use OAuth of other methods for authentication.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Secure write back possible in custom visual?

sschuetz — Mon, 12 Aug 2019 14:27:43 GMT

Hi @v-viig

What is the status of the Auth Api for Microsoft Services?

Thanks

Stefan

Re: Secure write back possible in custom visual?

shahsagarin — Wed, 23 Mar 2022 12:42:46 GMT

Hello:

Is there any update on this?