https://community.fabric.microsoft.com/t5/Report-Server/Report-builder-connection-to-Access-will-not-work-once-published/m-p/3235400#M29769 <P>I built a paginated report that has an MS Access database as its source. When I publish the report I cannot acccess it. I get the following error:</P><P>Unable to render paginated report<BR />There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid.<BR />Timestamp: 2023-05-10T10:36:55.812Z<BR />Root activity ID: fc2227fa-c74d-8a31-3114-8b5d28415c8c<BR />Session ID: 0000918024c24e01ad3df76a4cf95d2a<BR />Tenant ID: 78cfdb8f-c5d8-447a-bd00-4a88beced94a<BR />Cluster: <A href="https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/" target="_blank" rel="noopener">https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/</A><BR />Report ID: d719889b-76b3-4372-8959-2166384855a5<BR />ReportViewerVersion: 2023.5.1.704</P><P>&nbsp;</P><P>What is the best way to connect to an Access database?&nbsp;</P><P>&nbsp;</P> Mon, 15 May 2023 09:52:12 GMT ryeradio 2023-05-15T09:52:12Z https://community.fabric.microsoft.com/t5/Report-Server/Report-builder-connection-to-Access-will-not-work-once-published/m-p/3235400#M29769 <P>I built a paginated report that has an MS Access database as its source. When I publish the report I cannot acccess it. I get the following error:</P><P>Unable to render paginated report<BR />There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid.<BR />Timestamp: 2023-05-10T10:36:55.812Z<BR />Root activity ID: fc2227fa-c74d-8a31-3114-8b5d28415c8c<BR />Session ID: 0000918024c24e01ad3df76a4cf95d2a<BR />Tenant ID: 78cfdb8f-c5d8-447a-bd00-4a88beced94a<BR />Cluster: <A href="https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/" target="_blank" rel="noopener">https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/</A><BR />Report ID: d719889b-76b3-4372-8959-2166384855a5<BR />ReportViewerVersion: 2023.5.1.704</P><P>&nbsp;</P><P>What is the best way to connect to an Access database?&nbsp;</P><P>&nbsp;</P> Mon, 15 May 2023 09:52:12 GMT https://community.fabric.microsoft.com/t5/Report-Server/Report-builder-connection-to-Access-will-not-work-once-published/m-p/3235400#M29769 ryeradio 2023-05-15T09:52:12Z https://community.fabric.microsoft.com/t5/Report-Server/Report-builder-connection-to-Access-will-not-work-once-published/m-p/3239039#M29788 <P>64 bit only.</P> <P>&nbsp;</P> <P><A href="https://community.powerbi.com/t5/Service/On-Premise-Data-Gateway-and-Access-Databases/m-p/2301597" target="_blank">Solved: On-Premise Data Gateway and Access Databases - Microsoft Power BI Community</A></P> Wed, 17 May 2023 00:25:20 GMT https://community.fabric.microsoft.com/t5/Report-Server/Report-builder-connection-to-Access-will-not-work-once-published/m-p/3239039#M29788 lbendlin 2023-05-17T00:25:20Z