Dataflow doesn't load a table

[clem777]

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

[PijushRoy · Accepted solution]

Hi @clem777 

The error looks in Power Query steps 

In Pbix file, Take backup of Power Query code

Delete the table and refresh the report
Then rebuild the table and relationship.

I think you will find the error in in PQ Steps

[aj1973 · Accepted solution]

Hi @clem777 

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

[PijushRoy · Accepted solution]

Hi @clem777 

The error looks in Power Query steps 

In Pbix file, Take backup of Power Query code

Delete the table and refresh the report
Then rebuild the table and relationship.

I think you will find the error in in PQ Steps