Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 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

  • 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

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    Hi Anonymous 

    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's avatar
    aj1973
    Community 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