Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Using dataflow as a source for a datamart - 1 table is empty

I'm using a dataflow as a source for my datamart. I'm importing 4 tables from the dataflow, however 1 of the tables is empty (no rows) when I see it in the datamart. But when I check the table in the dataflow itself, the table does contain rows. For some reason, this same table is empty when imported into a datamart. 


What could be a possible reason for this? 


So far I have tried refreshing the dataflow & then the datamart, but i'm still facing the same issue.

Frequent Visitor

I have the same issue  ....

@v-binbinyu-msft I tried but it's doesn't work

Community Support
Community Support

Hi @yk98 ,

Please try below steps:

1. create a new dataflow with the same datasource, confirm the 4 tables have data

2. create a new datamart with the new dataflow

3. if it still not work, please change a new datasource to have a try


Best regards,
Community Support Team_ Binbin Yu

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors