Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
JFTxJ
Advocate III
Advocate III

Datamarts only able to Get Data from other datamarts or KSQL databases

I opened an existing datamart today (in Workspace A) that had data sourced from our Gold Lakehouse (in Workspace B).  Refreshes are working daily great and data is besing updated.

 

I needed to add a new table to the datamart from the same lakehouse, so I hit Get Data, only to discover that only Datamarts and KSQL databases are selectable in the "OneLake" section of the data sources.  I then tried to create a new datamart in the same workspace as the source lakehouse, but I got the same results.

JFTxJ_0-1702582806780.png

Notice the filters at the top only list Datamarts and KSQL.

 

Did something change?  Or am-I missing something?

 

Thank you

2 REPLIES 2
JFTxJ
Advocate III
Advocate III

Thank you Albert for this info.  It helps to know this does not affect all users.

I am a Fabric admin in my organization and I have admin role in all workspaces.  I do not know of any configurations that allows to limit the type of datasources for datamarts.

I have opened a support ticket (SR 2312150040004950) and someone is looking into the issue.

 

Thanks

Anonymous
Not applicable

Hi @JFTxJ ,

We tried to reproduce the problem ,but we were unable to reproduce it. Here are my screenshots:

vheqmsft_0-1702978782339.png

vheqmsft_0-1702978816694.png

Based on my understanding, there might be a restriction or a change in the settings that is limiting the data sources available to you. You can also check if there have been any updates or changes in the permissions or configurations that could be causing this issue.

 

Best Regards,

Albert He

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.