Forum Discussion
YevgenyM
Advocate IV
Advocate IVAccessing On-Prem API via Python/PySpark in Notebooks
Hi everyone, We have an on-prem Aruba API endpoint that's accessible through the Power BI gateway. I'm looking to access this data using Python or PySpark within Microsoft Fabric notebooks. ...
All right.
This is actually very often the case.However, we can think of two additional ideas.
Mirroring would be another idea if you already have the data in the SQL server or, as you have already written, incremental copy with CDC to a fabric SQL database.
Both are currently still in preview, but according to my tests they work very well.
Unless it is critical, these would be alternatives.Best regards
spaceman127
Super User
Super UserHi YevgenyM,
another option, if available, would be to use an Azure Function that retrieves the data and then stores it.
Of course, this requires a connection to on-premises.
Best regards