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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kkkttt
Frequent Visitor

Refresh Dataset with Python Scripts Without Personal Gateway?

Hi everyone,

 

I have some datasets published to Power BI Service which include python scripts in the Power Query.   Currently, I'm using Personal Gateway to refresh the datasets. 

I would like to know if there's any way to get rid of the Personal Gateway method, and refresh the dataset directly? 

e.g. setting up Azure Virtual Machine?

Fyi, my dataset is connecting to Azure's Cosmo DB (with Mongo API), in which it's currently not supported by Power BI.

 

Thanks in advance.

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. I'm sorry but Python Script must use a Personal Gateway. Even if you move to an Azure Virtual Machine. You need to install the gateway and python in there.

The only way to remove the personal is removing the python script. Using Power Query to make the transformation. Maybe this post can help you with that https://blog.ladataweb.com.ar/post/616019888350314496/power-query-pandas-and-sql-to-m

I hope this helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

1 REPLY 1
ibarrau
Super User
Super User

Hi. I'm sorry but Python Script must use a Personal Gateway. Even if you move to an Azure Virtual Machine. You need to install the gateway and python in there.

The only way to remove the personal is removing the python script. Using Power Query to make the transformation. Maybe this post can help you with that https://blog.ladataweb.com.ar/post/616019888350314496/power-query-pandas-and-sql-to-m

I hope this helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors