Forum Discussion

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
1 year ago
Solved

MS Fabric and MS Purview integration

Hi Everyone, Has anyone tried MS Purview integration with Fabric items. I did that but I noticed the assets that's getting identified does not included the delta tables residing in semantic model an...
Need Help
  • pallavi_r's avatar
    pallavi_r
    1 year ago

    Hi All,

     

    My issue got resolved. I am able to identify the power bi data assets now. I have added the purview managed indentity security group in the Fabric Workspace as contributer.

    Please ensure that Fabric Tenant and Purview network is public, else private endpoint needs to be created for the same.

    Thanks,

    Pallavi

pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
1 year ago

Hi All,

 

My issue got resolved. I am able to identify the power bi data assets now. I have added the purview managed indentity security group in the Fabric Workspace as contributer.

Please ensure that Fabric Tenant and Purview network is public, else private endpoint needs to be created for the same.

Thanks,

Pallavi

  • Banu_Murali's avatar
    Banu_Murali
    New Member
    1 year ago

    Hi Pallavi,

    Hope you doing great !!

     

    I am also facing same kind of issue in Purview not able to scan Lakehouse Delta tables in Purview. When I scan the Fabric workspace in Purview, I could able to see only Pipelines and Notebooks present in that workspace it doesn't identified Lakehouse tables as an asset. Prerequisites completed : Purview MSI granted with Contributor role access to our required workspace in Fabric and Enabled Fabric Tenant level settings with required Security group (where Purview MSI as a member).

     

    Could you please help me to solve it, how to identify Lakehouse tables as an asset and extract Metadata details of lakehouse tables in Purview. 

     

    Thanks in advance.

     

    Regards,

    BanuMurali

    • pallavi_r's avatar
      pallavi_r
      Icon for Super User rankSuper User
      1 year ago

      Hi Banu_Murali , 

      This is something I had done 2 months back, so sharing the observation and detail as of october 24. 

      -The metadata scan for all fabric item is done only at item level except power bi dataset.

      -Lakehouse table metadata scanning and lineage was not available. So individual tables and column inside lakehouse table was not discovered. Only lakehouse item was shown.

      -So I created a power bi report from the lakehouse->semantic model. And scanning extracted the metadata tables, column from power bi dataset along with basic lineage

      -Data Quality did not work for either.

      -I connected with Microsoft Support team. They did a great job and gave me detailed explaination saying quality scan for Lakehouse table is possible only whitelist the tenant. It is not available in public preview now, so if i raise a request to whitelist tenant  for lakehouse metadata scan and quality scan, then we can easily do it.

      Please check the Microsoft documentation again, as it might be available now. And check with Microsoft Support Team for this.

      If my answer helped you, then please give me a kudo.

      Thanks,

      Pallavi

    • ltofanelli's avatar
      ltofanelli
      Regular Visitor
      2 months ago

      The Purview MSI dosent work to ingest the lakehouse tables on data map. You need to create a new scan using a SPN that has access to Fabric APIs.