Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problem with refreshing dataset with connecting with MS Access in power bi cloud

I faced the error below when I refresh the dataset in the power bi cloud after creating it on PBI desktop and publishing it to PBI cloud. there's no Large Number (BigInt) column in the report source.

can anybody help me with this issue? please share your experience. thank you.

 

[Environment]

  • MS Access Version: 2302 16.0.16130.20186 32bit
  • PBI Desktop Version: 2.114.864.0 32-bit 

 

[Error Message]

데이터 원본 오류: {"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 database you are trying to open requires a newer version of Microsoft Access."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"MM_Dashboard.accdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: MARA.
클러스터 URI: WABI-US-NORTH-CENTRAL-C-PRIMARY-redirect.analysis.windows.net
활동 ID: b3f2ef75-fb53-4a68-ad30-9e9253732ac2
요청 ID: d233c73b-1243-4b61-7d00-23ff52b72052
시간: 2023-03-09 05:21:49Z

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please try below steps:

    1. If you haven't already installed a data gateway locally, please install and configure one now

    2. If you have already installed a data gateway locally, please try to upgrade it or uninstall and reinstall it

    For more details, you can read related document: Install an on-premises data gateway | Microsoft Learn,

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Please try below steps:

    1. If you haven't already installed a data gateway locally, please install and configure one now

    2. If you have already installed a data gateway locally, please try to upgrade it or uninstall and reinstall it

    For more details, you can read related document: Install an on-premises data gateway | Microsoft Learn,

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for your help.