Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Known Dataflow Error Starting ~11/14

  • 1.  Known Dataflow Error Starting ~11/14

    Bronze Contributor
    Posted 26 days ago
    I thought I'd share a thread from another board where several Users, including myself, started encountering issues with Dataflows starting mid to late this past week. https://community.powerbi.com/t5/Service/Just-started-this-week-DATAFLOW-table-does-not-show-up-in-Power/td-p/847988

    Symptoms include:
    • Failed Dataflows, both manual and scheduled
    • Even in Dataflows that have been running without intervention, they prompt for credentials
    • Dateflow Entities with DATE columns have been somehow changed to UNCLASSIFIED and are the cause of the error.  Entities that do not include DATE columns work as expected.
    • When attempting to manually refresh a Dataset that includes Dataflows in question, it fails.  In the Power Query editing the error code is "Key does not match any rows", meaning it can't find the Dataflow

    The solution involves manually updating the DATE column types.  Please refer to the link above for additiional detail on solutions.

    Thanks and good luck!

    Mike

    ------------------------------
    Michael Greez
    Commercial Operations & Analytics
    Watertown MA
    5088576280
    ------------------------------
    Conference-PBI_200x200