Home › Forums › Dynamic Ship › Dynamic Ship Analysis – trouble with database refresh

Tagged: 

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • John GiordanoJohn Giordano
      September 10, 2026 at 6:50 am
      Post count: 29
      #16293

      All, I have been working to get teh Dynamic Ship Analysis app functional again within our Power BI environment, but every time I attempt to reset my credentials and database connection informaiton, it failes to refresh and I get the following error:

      <ccon>Expression.Error: The key didn’t match any rows in the table.. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [Name = “Jo-Kell, Inc.”]. Table = #table({“Name”, “Display_Name”, “Data”, “ItemKind”, “ItemName”, “IsLeaf”}, {}). </ccon>. The exception was raised by the IDbCommand interface.

      This morning, I deleted it from our PBI envirnment and reloaded the app from the Marketplace. It still failed after going through the initialization steps it walks your through.

      Before I replaced the app, I noticed the last known valid refresh occurred in mid-February, according to the date on the semantic model refresh information.

      What can I do to fix this issue?

      Jason EspirituJason Espiritu
        September 10, 2026 at 7:58 am
        Post count: 4
        #16294
        Upvote
        Up
        0
        Down
        Not Helpful
        ::

        Hi John,

        Thanks for reaching out.

        This error could indicate that Power BI is unable to find the Jo-Kell, Inc. company in the connected Business Central environment.

        Could you please verify that:

        • Jo-Kell, Inc. is still the exact company name in Business Central.
        • The Dynamic Ship extension is installed and up to date in the Business Central environment.
        • The account being used for the Power BI connection has access to the Jo-Kell, Inc. company.
        • The Power BI connection is pointing to the correct Business Central environment.

        If all of the above are correct and the issue persists, please let us know.

        Regards,
        Jason

        John GiordanoJohn Giordano
          September 10, 2026 at 12:35 pm
          Post count: 29
          #16310
          Upvote
          Up
          0
          Down
          Not Helpful
          ::

          Jason, to answer your questions directly;

          • Jo-Kell, Inc. is still the exact company name in Business Central. — yes that is correct as Jo-Kell, Inc.
          • The Dynamic Ship extension is installed and up to date in the Business Central environment. — my version in BC shows 1.0.0.0 yet the current version on your app-release tracker page shows 1015, and that’s what shows on teh Appsource page. I can’t get a new version to download from app center. Can you provide a link, or how can I get the proper most up-to-date version for upload to BC?
          • The account being used for the Power BI connection has access to the Jo-Kell, Inc. company. — yes, it’s my account
          • The Power BI connection is pointing to the correct Business Central environment. — yes, it is our Production environment and this had been working up until February from what i can tell.

          Thanks,

          John

          • This reply was modified 3 weeks, 5 days ago by John GiordanoJohn Giordano.
          Jason EspirituJason Espiritu
            September 10, 2026 at 1:31 pm
            Post count: 4
            #16313
            Upvote
            Up
            0
            Down
            Not Helpful
            ::

            Hi John,

            In order for us to provide you with the appropriate app file, could you please provide the following details?

            What version of Business Central are you currently using?
            Is the environment SaaS or On-Premises?

            Regards,
            Jason

            • This reply was modified 3 weeks, 5 days ago by Jason EspirituJason Espiritu.
            Jason EspirituJason Espiritu
              September 10, 2026 at 2:36 pm
              Post count: 4
              #16318
              Upvote
              Up
              0
              Down
              Not Helpful
              ::

              Hi John,

              I think it would be better to go over this on a call.

              You can schedule a meeting with us using the link below:
              https://calendly.com/d/dvwz-vjf-d2v

              Regards,
              Jason

              John GiordanoJohn Giordano
                September 11, 2026 at 5:36 am
                Post count: 29
                #16321
                Upvote
                Up
                0
                Down
                Not Helpful
                ::

                Jason, I will use the link provided above to set an support call. For more information going into it, we reloaded the extension last night around 930pm, and the connection still failed during refresh. Here are the details:

                Last refresh failed: 9/11/2026, 12:25:38 AM
                An error occurred while processing the semantic model.Hide details
                Data source error: Expression.Error: The key didn’t match any rows in the table.. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [Name = “Jo-Kell, Inc.”]. Table = #table({“Name”, “Display_Name”, “Data”, “ItemKind”, “ItemName”, “IsLeaf”}, {}). . The exception was raised by the IDbCommand interface.
                Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
                Activity ID: b4464c47-754f-4e0f-86f0-f555aaa717b3
                Request ID: 850f2629-d4b5-42fa-97ad-a466cc6c7bcd
                Time: 2026-09-11 04:25:38Z

                BC version: Version: US Business Central 28.5 (Platform 28.0.54016.0 + Application 28.5.54151.54262)
                Dynamic Ship Analysis version: still sitting at 1.0.0.0 even after reloading

                Thanks,

                John

              • Author
                Posts
              Viewing 6 posts - 1 through 6 (of 6 total)
              • You must be logged in to reply to this topic.