Forum Discussion
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
- Anonymous3 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
- AnonymousNot 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. - AnonymousNot applicable
Thanks for your help.