Dataflow stopped working after adding columns in source database table

[bitkompis]

We have created dataflow that connects to MySql database.  This happended a month ago and have worked fine.

Two additional columns are added in the source database table today.  And after that our dataflow stopped working.  This issue occurs many ways:

1. Currently used dataflow connection in Power BI desktop is unable to read data from the table: Expression.Error: The key didn't match any rows in the table.

2. We tried to create a new dataflow that connect to the same database table.  Creation seems to work fine and data load as well.  but when we tried to connect to it using Power BI desktop, Dataflow is in the available dataflows list, but it is empty (no entity that referts to the database table)

3. We tried to reload dataset that is connected to the dataflow in Power BI service, but error occured: The key didn't match any rows in the table. Table: <table name>

4. 3. We tried to reload dataset that is connected to the dataflow in Power BI dekstop, but error occured: The key didn't match any rows in the table. Table: <table name>

[v-qiuyu-msft]

Hi @bitkompis, 

Does the entity contain any date type column? 

If it is, the issue should be the same as the one in this thread: https://community.powerbi.com/t5/Service/Just-started-this-week-DATAFLOW-table-does-not-show-up-in-P...

ETA for fix is end of week.

Best Regards,
Qiuyun Yu