Forum Discussion
Advocate IVAccessing On-Prem API via Python/PySpark in 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
Community SupportHello YevgenyM,
Thank you for reaching out to the Microsoft fabric community forum.
Microsoft Fabric notebooks (Python/PySpark) don’t currently support direct connections to on-premises APIs via the Power BI gateway. A recommended workaround is to use an on-premises script to call the Aruba API and push the data to OneLake or Azure Data Lake Storage, which can then be accessed in Fabric notebooks. Configure the gateway to ensure network access to the API, store credentials securely and use PySpark to process the data in Fabric.
Best regards,
Ganesh Singamshetty.
Advocate IVDo you know if it is planned in the future to be supported?
- v-ssriganesh
Hello YevgenyM,
Currently, direct support for on-premises APIs through the gateway in Fabric notebooks is not available, and Microsoft has not announced a roadmap or ETA for this specific capability.
I’d recommend keeping an eye on the official Microsoft Fabric release notes: https://learn.microsoft.com/en-us/fabric/fundamentals/whats-new and also submitting this idea in the Fabric Ideas forum: https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas. The more community votes an idea receives, the more likely it is to be considered by the product team for future updates.
Best regards,
Ganesh Singamshetty