Solved: update access from dataflow

pakovic · ‎02-10-2023

in Dataflow when I try to bring an access file from onedrive, I get a message that I have to install the 64 bit version on my computer, but the file I have uploaded from access is a 64 bit version.

edhans · ‎02-10-2023

Access MUST be accessed via a gateway. You cannot connect directly to an MDB or ACCDB file. This article shows both the Gateway is required, and you must have the 64bit ACE OLEDB driver installed on it. Power BI data sources - Power BI | Microsoft Learn

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

edhans · ‎02-10-2023

Access MUST be accessed via a gateway. You cannot connect directly to an MDB or ACCDB file. This article shows both the Gateway is required, and you must have the 64bit ACE OLEDB driver installed on it. Power BI data sources - Power BI | Microsoft Learn

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

update access from dataflow

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024