Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to update the report autometically with Access database

Hi,   I've used Power BI as below process.   Data input to Access (which is located in Sharepoint) → Bring data from Access to PowerBI desktop and make a report → Publish this rerpot to the web P...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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