Forum Discussion

Eladb's avatar
Eladb
New Member
3 years ago

Data set not refreshed error 2147467259

Hi All,

 

problem about a week, please help!

in desktop everything works.

published successfully.

data set is not refreshed, why???

 

 

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 'afn1gb1q.xlsx' 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":"afn1gb1q.xlsx"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: 2023.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: e2322627-3293-4a36-a60c-44afb40163f3
Request ID: 123a1133-6d8f-449b-83b3-f7b4d3219cc1
Time: 2023-02-18 20:01:14Z

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Eladb ,

    Do you get this error when you refresh on the desktop? If it refreshes successfully on the desktop, will it refresh successfully after uploading directly to service?

     

    It might be related to the credentials to access the data source. 

    Have a try.

    Clear the  cache - went to "data source settings" and cleared all permissions - then recaptured them.

     

    Or change the browser. Try to use the Edge.

     

    I have also found a similar post, please refer to it to see if it helps you.

    Solved: Gateway Refresh error indicating missing column - Microsoft Power BI Community

     

    If it does not help, please provide more details with the error.

     

    Best Regards
    Community Support Team _ Polly

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