Gateway Alternative for Python Script

[Babakhsn]

Hello everyone,

I have a Power BI report that is using Python. I have published this report to Power BI Service, created a Power BI App and I am using a personal gateway for python. 

I am the administrator of this App and I have given access to everyone in my organization to be able to see the app.

The problem is that if someone besides me wants to update the app, they can't, because my local computer would be off and the gateway won't work.

I'm thinking of creating another cloud connection that could host the python code, so that the report is not dependent on my personal gateway.

Does anyone have a suggestion on how to do this, 

or another idea entirely on how to solve this problem?

Thanks in advance.

[ibarrau]

Hi. Sure. Depending on how complex the code is, there are services for running code at cloud vendors. For example, lambda at aws. In my case I have run tests for this same scenarios with Azure Functions. 

Feel free to check how to build an Azure Function for this in the following post (it's in spanish, but translate it with browser)

https://blog.ladataweb.com.ar/post/730250672108388352/origen-web-para-evitar-gateway-powerbi-y-azure

I hope that helps,

[Babakhsn]

Dear @ibarrau 

Thanks for your reply.

This was exactly what I needed but I have some difficulty understanding the __init__.py files purpose.

Are we putting all of our Power BI credentials into this file and the using this file in function_app.py?

This part of the blog is a bit vague to me.

BR,

Babak

[ibarrau]

Hi. The init it's the file that contains the logic you are building for the web request call you should send from PowerBi. The main in this case it's a GET showing what you would like to return. The example is connecting to an API to help make sense of an scenario that might be frequent if the API is complex to handle it by Power Query. The exposed password shouldn't be like that in a production environment. It must be configured at an Azure KeyVault in order to keep a variable that can't show the value of the key/password. This post is just to get the idea of using Azure Functions as web source.

I hope that make sense