Forum Discussion
How to update the report autometically with Access database
Anonymous,
Firstly, Power BI Desktop can be downloaded from here. Go to "Get Data" in Power BI Desktop and you can see Access database connector.
Secondly, personal mode gateway can be used to set schedule refresh.
Thirdly, if you connect to online data sources such as SharePoint online list in Power BI, you can set schedule refresh for your dataset without gateway.
Regards,
Lydia
Anonymous,
Do you use Access database connector in Power BI Desktop to connect to your Access data source? If so, after you publish the PBIX file to Power BI Service, you would need to use personal mode gateway instead of on-premises gateway to refresh the dataset. There is no Access option in on-premises gateway.
If you don't want to use gateway in this scenairo, you can store Access tables as SharePoint online list, then connect to the online list in Power BI Desktop and create report. There is a similar thread for your reference.
Regards,
Lydia
Hello Lydia,
Thank you very much for the reply. Actually, the ultimate goal is to do scheduled refresh.
I have few more questions regarding this.
- Is scheduled refresh available to do without Gateway?
- Is scheduled refresh available to do with Personal Gateway as well?
(Since as I know, scheduled refresh is only available when we have Premium Gateway or PowerBI..?)
- May I know what is the Access Database Connector in Power BI Desktop and where could I find it to download?
I'm so beginner in PowerBI so maybe the questions look silly.. Many thanks in advance!
Anonymous,
Firstly, Power BI Desktop can be downloaded from here. Go to "Get Data" in Power BI Desktop and you can see Access database connector.
Secondly, personal mode gateway can be used to set schedule refresh.
Thirdly, if you connect to online data sources such as SharePoint online list in Power BI, you can set schedule refresh for your dataset without gateway.
Regards,
Lydia