In the Access database dialog that appears, provide the path to the Access database.Įnter the file path or URL address to the Access database. In Navigator, select the database information you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor.Ĭonnect to an Access database from Power Query Online If the Access database is online, use the Web connector to connect to the database. Select the Access database option in the connector selection.īrowse for and select the Access database you want to load. To make the connection from Power Query desktop: Capabilities SupportedĬonnect to an Access database from Power Query Desktop For more information, go to Import Access database to Power BI Desktop. If you're loading an Access database to Power BI Desktop, the versions of the Access Database Engine 2010 OLEDB provider and Power BI Desktop on that machine must match (that is, either 32-bit or 64-bit). If you're connecting to an Access database from Power Query Online, the system that contains the on-premises data gateway must have the 64-bit version of the Access Database Engine 2010 OLEDB provider installed. Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |