Forum Discussion
Semantic model displays empty tables from Dataflow
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
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 LearnAlso, 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
11 Replies
I haven't seen this issue before. Can you add more details to like some screenshots here?
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.
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?
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.
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.
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.
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.
