Forum Discussion

YevgenyM's avatar
YevgenyM
Icon for Advocate IV rankAdvocate IV
1 year ago
Solved

Accessing 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. ...
data engineering
notebook
  • spaceman127's avatar
    spaceman127
    1 year ago

    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 

YevgenyM's avatar
YevgenyM
Icon for Advocate IV rankAdvocate IV
1 year ago

v-ssriganesh

Do you know if it is planned in the future to be supported? 

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

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