cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
numersoz Regular Visitor
Regular Visitor

Using Power BI Desktop on Cloud with Python Support to Get Data

Hi,

I've just learned that it is possible to use a Python script to get data in Power Query. I will use Python to get data from an API. I know I can do this with Power Query too, but there are too many parameters involved and I feel more confident using Python, as with M code it will be too complicated for me.  .

I need the dashboard that I created using Python to get the data on the cloud.  On-Premises Data Gateway lets you use your Power BI Desktop file which has Pyhton script in it so that it can be published online. But my laptop isn't going to be on 24/7. What would be the ideal environment to have this Power BI Desktop file run on?

Should I get an Azure virtual machine? I really don't want to get a virtual machine and pay for it just for this purpose. Is there a better way to do this?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Using Power BI Desktop on Cloud with Python Support to Get Data

Hi @numersoz 

If your data source is online, you don't need a gateway to refresh data automatically.

Using the data source with power bi desktop, after publishing to service, go to Setting->dataset->select this dataset->schedule refresh->edit credentials.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

numersoz Regular Visitor
Regular Visitor

Re: Using Power BI Desktop on Cloud with Python Support to Get Data

@v-juanli-msft Hi Maggie,

Yes, the data is online, but I am planning to use Python to get this data. If I upload the Power BI, will it still be able to run the Python script to get the data? When you use to get data from Python, you have to specify your Python interpreter. How would I do this online?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors