The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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:
Unable to render paginated report
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.
Timestamp: 2023-05-10T10:36:55.812Z
Root activity ID: fc2227fa-c74d-8a31-3114-8b5d28415c8c
Session ID: 0000918024c24e01ad3df76a4cf95d2a
Tenant ID: 78cfdb8f-c5d8-447a-bd00-4a88beced94a
Cluster: https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/
Report ID: d719889b-76b3-4372-8959-2166384855a5
ReportViewerVersion: 2023.5.1.704
What is the best way to connect to an Access database?