https://community.fabric.microsoft.com/t5/Developer/Getting-failed-to-update-Data-source-credentials-error-while/m-p/2509868#M36051 <P>Hi Team,</P><P>&nbsp;</P><P>I'm building a report for which data source is Access Database. I've called the data via Access DB data source in Get data and built the report and published it in Power Bi service. But in data source credentials i'm getting error as "<STRONG>Could not find file</STRONG>" even the path is correct and file is available in that path.&nbsp;</P><P>&nbsp;</P><P>Kindly help to find me a solution for this. Besides I also want to know is it related to gateway connection and does Access DB support on-Permesis gateway?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HaveeshPerla_1_1-1652343271227.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/713497i0369255506BE676F/image-size/medium?v=v2&amp;px=400" role="button" title="HaveeshPerla_1_1-1652343271227.png" alt="HaveeshPerla_1_1-1652343271227.png" /></span></P><P>&nbsp;</P><P>Regards,</P><P>Haveesh&nbsp;</P> Thu, 12 May 2022 08:15:08 GMT Anonymous 2022-05-12T08:15:08Z https://community.fabric.microsoft.com/t5/Developer/Getting-failed-to-update-Data-source-credentials-error-while/m-p/2509868#M36051 <P>Hi Team,</P><P>&nbsp;</P><P>I'm building a report for which data source is Access Database. I've called the data via Access DB data source in Get data and built the report and published it in Power Bi service. But in data source credentials i'm getting error as "<STRONG>Could not find file</STRONG>" even the path is correct and file is available in that path.&nbsp;</P><P>&nbsp;</P><P>Kindly help to find me a solution for this. Besides I also want to know is it related to gateway connection and does Access DB support on-Permesis gateway?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HaveeshPerla_1_1-1652343271227.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/713497i0369255506BE676F/image-size/medium?v=v2&amp;px=400" role="button" title="HaveeshPerla_1_1-1652343271227.png" alt="HaveeshPerla_1_1-1652343271227.png" /></span></P><P>&nbsp;</P><P>Regards,</P><P>Haveesh&nbsp;</P> Thu, 12 May 2022 08:15:08 GMT https://community.fabric.microsoft.com/t5/Developer/Getting-failed-to-update-Data-source-credentials-error-while/m-p/2509868#M36051 Anonymous 2022-05-12T08:15:08Z https://community.fabric.microsoft.com/t5/Developer/Getting-failed-to-update-Data-source-credentials-error-while/m-p/2516212#M36115 <P>Hi&nbsp;@Anonymous&nbsp;,</P> <P>The Access database is supported by Gateway, you can find the details in <A href="https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources#data-sources-a-b" target="_self">this official documentation</A>.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_0-1652667124155.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/715264iDC6C3D47C7F3AB8C/image-size/large?v=v2&amp;px=999" role="button" title="yingyinr_0-1652667124155.png" alt="yingyinr_0-1652667124155.png" /></span></P> <P><SUP>1</SUP><SPAN>&nbsp;Supported with the&nbsp;</SPAN><A href="https://www.microsoft.com/download/details.aspx?id=54920" data-linktype="external" target="_blank">ACE OLEDB provider</A><SPAN>, installed on the same machine as the gateway.</SPAN></P> <P><SPAN>Regarding to your problem, please review the following link and check if it can resolve your problem.</SPAN></P> <P><A href="https://docs.microsoft.com/en-us/power-query/connectors/accessdatabase#on-premises-data-gateway-error" target="_self"><SPAN>On-premises data gateway error</SPAN></A></P> <BLOCKQUOTE> <P>A 64-bit version of the Access Database Engine 2010 OLEDB provider <STRONG>must be</STRONG> installed on your on-premises data gateway machine to be able to load Access database files. If you already have a 64-bit version of Microsoft Office installed on the same machine as the gateway, the Access Database Engine 2010 OLEDB provider is already installed. If not, you can download the driver from the following location:</P> <P><A href="https://www.microsoft.com/download/details.aspx?id=13255" data-linktype="external" target="_blank">https://www.microsoft.com/download/details.aspx?id=13255</A></P> <HR /></BLOCKQUOTE> <P><A href="https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-access-database-errors" target="_self">Troubleshoot importing Access and Excel .xls files in Power BI Desktop</A></P> <P>In addition, you can refer the following thread to add Access data source in the gateway.</P> <P><A href="https://community.powerbi.com/t5/Power-Query/Using-MS-Access-as-a-data-source-with-On-Premises-Data-Gateway/td-p/451433" target="_self"><SPAN>Using MS Access as a data source with On-Premises Data Gateway</SPAN></A></P> <P>Best Regards</P> Mon, 16 May 2022 03:17:47 GMT https://community.fabric.microsoft.com/t5/Developer/Getting-failed-to-update-Data-source-credentials-error-while/m-p/2516212#M36115 Anonymous 2022-05-16T03:17:47Z