Semantic model displays empty tables from Dataflow

[DataVitalizer]

Hi Community,

I created a Dataflow in Power BI Service and confirmed that it shows data correctly in the Power Query Online editor. However, when I build a Semantic Model based on that Dataflow, the tables appear with headers but no rows.

Has anyone run into this issue?

Any suggestions would be appreciated

🟩 Follow me on LinkedIn

[v-hashadapu]

Hi @DataVitalizer , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

[v-hashadapu]

Hi @DataVitalizer , Hope you are doing well. Kindly let us know if the issue has been resolved or if further assistance is needed. Your input could be helpful to others in the community.

[DataVitalizer]

Thank you for your reply @Pragati11 , @tayloramy , here are a few screenshots:

Dataflow

Semantic Model

Thank you in advance.

🟩 Follow me on LinkedIn

[tayloramy]

Has both the dataflow and semantic model refreshed successfully? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[Pragati11]

Hi @DataVitalizer 

Two questions from my side:

- Did your dataflow got saved and refreshed without errors on the first go?

- Is this a Dataflow Gen2? If yes, did you give proper destination before saving & refreshing it?

[DataVitalizer]

Hi @Pragati11 

- Did your dataflow got saved and refreshed without errors on the first go? > YES

- Is this a Dataflow Gen2? If yes, did you give proper destination before saving & refreshing it? Gen1

Thank you in advamnce.

🟩 Follow me on LinkedIn

[v-hashadapu · Accepted solution]

Hi @DataVitalizer , Thank you for reaching out to the Microsoft Community Forum.

This is most likely a credentials/permission or refresh materialization issue. Re-enter the Power BI Dataflows credentials, fully refresh the dataflow, then refresh the semantic model. If it still shows headers only, materialize the entity (create a staging table), re-link it to the model and if that fails export/import the dataflow.

If none of that works, I suggest collecting the refresh logs and opening a Microsoft Support ticket. Below is the link to help create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Also, please refer:

Troubleshooting dataflow issue - get data from dataflow - Power Query | Microsoft Learn

Configure and consume a dataflow - Power BI | Microsoft Learn

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

Connect to Power Platform dataflows in Power BI Desktop - Power BI | Microsoft Learn

[DataVitalizer]

Hi @v-hashadapu Thank you for the reply.
I will give it a try and keep the community updated with the results.

Any suggestions would be appreciated

🟩 Follow me on LinkedIn

[v-hashadapu]

Hi @DataVitalizer , thanks for the update. Please do share the results.

[tayloramy]

Hi @DataVitalizer, 

As @Pragati11 asked, some screenshots and more details would be helpful for us to help. 

One thing that comes to mind for me, has the dataflow successfully refreshed at all? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[Pragati11]

HI @DataVitalizer 

I haven't seen this issue before. Can you add more details to like some screenshots here?