Power BI Exchange

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

Known Dataflow Error Starting ~11/14

  • 1.  Known Dataflow Error Starting ~11/14

    Bronze Contributor
    Posted Nov 17, 2019 04:00 PM
    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Known Dataflow Error Starting ~11/14

    Posted Feb 12, 2020 08:38 PM

    I Love U Michael Greez!

    Thank you!



    ------------------------------
    João Flávio Santos
    Analist
    ------------------------------

    Academy - Online Interactive Learning from Experts