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 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

  • JohnHu's avatar
    JohnHu
    Icon for Advocate I rankAdvocate I
    1 year ago

    Hi All,

    I am also having this issue.  Custom semantic models in Fabric Workspaces appear in Purview as Power BI Datasets, however default semantic models (automatically created when a Lakehouse is created) are not ingested into Purview.  This is a huge issue.

     

    This is a huge issue, because if I have 40 tables in a Lakehouse, in order to ingest them into Purview as Data Assets (Power BI Datasets), I would need to create a custom Semantic Model in Fabric for each table!  

     

    Is there an easier way?