Forum Discussion
pay_2019
Advocate I
Advocate IUsing a linked Excel file in Access and having trouble with scheduled refresh in Power BI
I have a linked excel document held in my Access database which I use to create Power BI reports. The Access database also pulls in data on other ODBC links with third party software. When I refresh ...
I have resolved it by using the table in Access and creating a schedule update to make the table using AutoSQL. Not ideal but it now allows me to set the schedule refresh up and is working.
pay_2019Advocate I
Advocate II have resolved it by using the table in Access and creating a schedule update to make the table using AutoSQL. Not ideal but it now allows me to set the schedule refresh up and is working.