Forum Discussion

Amiral's avatar
Amiral
Frequent Visitor
1 year ago
Solved

Fabric Secure solution for Data Sharing for Multi-Authentication users

Hi Community, What is the best practices today to share refreched data with different users specially in json format. Is it possible to share REST API as in Databricks ? Any other solution ? ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Amiral,

    Thank you for reaching out in Microsoft Community Forum.

    1. Please Use Synapse Data Hub with API Management or Azure Functions to expose refreshed data via a REST API.

    2. Export data from Power BI datasets in JSON format using the Power BI REST API.
    GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/rows

    3.In Fabric notebooks, export Lakehouse data to JSON:
    df.to_json('/lakehouse/default/Files/exported_data.json', orient='records', lines=True)

    Please continue using Microsoft community forum.

    If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

    Regards,
    Pavan.