Forum Discussion
Dataflow doesn't load a table
I have a dataflow with several tables. One of my reports is based on this dataflow and it used to work well until last week : one of the table is not loaded anymore.
1/ When I open the pbix file and try to transform data : the table "Plants" appears with an error :
2/ When I click edit settings, i see this :
3/ Then, I have a look at the dataflow. I find that the table is empty
4/ But when I click Edit Tables, I can see data in the Power Query editor :
I don't understand why I can see data in stage 4/ but the table is empty in stage 3/.
Additional information :
- I directly queried the Oracle database to make sure the table actually contains data.
- The dataflow is refreshed daily.
I am not able to solve it by myself so far, help will be appreciated
Best regards,
Clément
Hi Anonymous
The error looks in Power Query steps
In Pbix file, Take backup of Power Query codeDelete the table and refresh the report
Then rebuild the table and relationship.
I think you will find the error in in PQ StepsHi Anonymous
Delete the last step"Rename.." in Power Query Online of the Table Plans, refresh it and then republish the dataflow.
Refresh as well the Dataflow and then go back to your PBIX and refresh it.
Let me know
2 Replies
- PijushRoyCommunity Champion
Hi Anonymous
The error looks in Power Query steps
In Pbix file, Take backup of Power Query codeDelete the table and refresh the report
Then rebuild the table and relationship.
I think you will find the error in in PQ Steps - aj1973Community Champion
Hi Anonymous
Delete the last step"Rename.." in Power Query Online of the Table Plans, refresh it and then republish the dataflow.
Refresh as well the Dataflow and then go back to your PBIX and refresh it.
Let me know