In my .pbix, my data consists of 4 queries:
One query is a Python.Execute the other 3 are Sql.Database.
- The SqlServer is on-prem and I already have a gateway installed there…
- The python one is a call to an API to bring my fact table
I want to publish it and have it updated automatically every Sunday night. What’s the standard way of achieving this?
I understand I need a PERSONAL gateway for the python, but, where do I install it?
My laptop doesn’t seem the right place because… When the update shall run on Sunday, my laptop is going to be off.
(we have a P1 Premium capacity)
from how to automate my sources? (python and SqlServer)
No comments:
Post a Comment