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 ?

Thank you

admin
capacities
one lake
security
workspaces
  • 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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Amiral,

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

    Thank you,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Amiral,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

    Thank you,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Amiral,

    I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
    If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
    If you need any further assistance, feel free to reach out.

    Please continue using Microsoft community forum.

    Thank you,
    Pavan.