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?
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?