Forum Discussion
Semantic model displays empty tables from Dataflow
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
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.
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
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
Hi DataVitalizer , thanks for the update. Please do share the results.