Forum Discussion

Creature's avatar
Creature
Frequent Visitor
2 years ago

Data Source Error Help

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The column 'Column1' of the table wasn't found."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"Column1"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: EUCS 2023.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 6e141c26-9c8c-449e-8327-b1da46f19070
Request ID: 3490f8f1-1db4-8cfe-04c0-6ea7c019da3d
Time: 2023-12-01 23:51:07Z

 

This what I am recieving when trying to refresh a data set. Unsure what the error could be?

 

Tried - Re uploading it, verifying data/column names. Gateway is configured correctly. Etc

Need Help

4 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    Hi Creature 

    Go back to Power Query editor and check out the problem with this column

     

    • Creature's avatar
      Creature
      Frequent Visitor
      2 years ago

      Ive Tried to delete, re add, rename, recreate this column and still get an error message with said column

      • aj1973's avatar
        aj1973
        Community Champion
        2 years ago

        The source of this table, what is it? excel?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Creature ,

     

    During my investigation I have found users in the past who have had similar experiences to you .
    The solution given by other forum users was:You have created multiple connections with different credentials.

     

    For original post, you may refer to

    Solved: Underlying error message: The column 'Column1' of ... - Microsoft Fabric Community

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.