Data portal with Google-like search features for data sharing in Fabric

[Sankar_Krishna]

Hello,

We are currently in the design phase of building a Medallion architecture in Fabric. As part of this, we plan to create semantic models and large, consolidated "gold layer" tables in the data lake for end-user consumption.

We are considering using Profisee for Master Data Management and OvalEdge for Data Quality.

The current requirement is to implement an internal data marketplace where business users can:

• Discover available data
• View data quality scores (e.g., validity, accuracy)
• Understand data context using a business glossary
• Request and gain access to the data products they need

Can Microsoft Purview support this kind of UI for end users?
Or is there another service/layer that better enables a self-service data consumption experience?

Best regards,
Sankar Krishna

[Teddyb]

Hi @Sankar_Krishna  are you aware that Profisee is integrated with Fabric? You can get Profisee from the workload Hub: https://app.fabric.microsoft.com/workloadhub/detail/Profisee.MDM.Product?experience=fabric-developer

Also, you can consider building an internal marketplace experience for your organization in Fabric by using: Microsoft Fabric Workload Development Kit - Microsoft Fabric | Microsoft Learn

[Anonymous]

Hi @Sankar_Krishna,

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.

Thank you,
Pavan.

[Anonymous]

Hi @Sankar_Krishna,

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]

Hi @Sankar_Krishna,

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.

[burakkaragoz]

Hi @Sankar_Krishna ,

Use Basic Authentication Instead of Windows Authentication

If you're using Windows Authentication or a domain account, try switching to basic authentication with a direct username and password in the gateway connection settings. PostgreSQL often works more reliably this way in gateway scenarios.

Check PostgreSQL pg_hba.conf File

Make sure the PostgreSQL server’s pg_hba.conf file allows connections from the IP address of the machine where the gateway is installed. Even if telnet works, PostgreSQL might still reject the connection based on authentication method or host rules.

Example entry:

host    all             all             0.0.0.0/0               md5

Try a Lower PostgreSQL Version Temporarily

There have been cases where newer PostgreSQL versions (e.g., 15+) had compatibility issues with certain gateway builds. If possible, test with a PostgreSQL 13 or 14 instance to rule out version-specific issues.

Let us know if any of these help—or if you can share the exact PostgreSQL version and connector type you're using, we can dig deeper.

[burakkaragoz]

I have also collected some other information below, which may be helpful.

we had a similar ask in our org – basically a data portal where users can search, understand, and request access to data without needing to know the backend.

Here’s what we ended up doing (Purview alone wasn’t enough tbh):

---

1. Search & Discovery
Purview is good for metadata search, but not very “Google-like”. We added a custom front-end (Power Pages) that queries Purview API and shows results in a cleaner UI.

2. Data Quality
We used Fabric Dataflows + Azure Data Factory to calculate quality metrics, then pushed those as custom metadata into Purview. Not native, but works.

3. Glossary & Context
Purview’s business glossary is decent. Just make sure your terms are well defined and linked to assets.

4. Access Requests
This was the tricky part. We built a Power Automate flow triggered from a Power App form. It sends approval requests to data owners and updates access in Entra ID groups.

---

If you want a more plug-and-play solution, tools like OvalEdge or Alation might be better suited for full marketplace features.

Let me know if you want a sample Power App + Automate setup, happy to share.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[Sankar_Krishna]

Thank you Pavan , understood . It looks to me like between oval Edge , Purview and RPA we should be able to build this out . 

[Anonymous · Accepted solution]

Hi @Sankar_Krishna,

Thank you for reaching out in Microsoft Community Forum.

Microsoft Fabric works well with Purview for data discovery, governance, and business glossaries. For access requests, Fabric doesn’t have a built-in approval system, but you can use Power Automate and Microsoft Entra ID (Azure AD) to create automated workflows for that.

As for data quality, Fabric doesn’t have native scoring, so integrating with tools like OvalEdge or Azure Data Factory is common. You can then surface those quality scores in Purview for users to see.

In short, Fabric and Purview together cover a lot, but building a full self-service data marketplace usually means bringing in a few complementary tools.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.

[Anonymous]

Hi @Sankar_Krishna,

Thank you for reaching out in the Microsoft Community Forum.

Yes, Microsoft Purview can support many of the capabilities you're aiming for in your internal data marketplace.

Please find below what purview offers;

1.Purview provides a unified data catalog that allows users to search, browse, and explore datasets across your data estate.

2.While data quality scoring is not native in Purview, it can be integrated with tools like Azure Data Factory, Fabric Dataflows, or third-party solutions like OvalEdge. You can then register metadata or quality scores into Purview via its API.

3.Purview supports rich business glossaries, allowing users to understand the context of data assets using well-defined business terms.

4.While Purview enables you to view access policies, it does not currently support built-in workflow mechanisms for requesting and approving access. You may need to integrate it with Power Automate, Microsoft Entra ID (RBAC), or other governance tools to handle access requests more dynamically.

Please continue using Microsoft Community Forum.

If this post helped resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan