Forum Discussion

Clout's avatar
Clout
Helper III
5 years ago
Solved

Set access data from sharepoint as source

Hello guys,   my organizatian has a access database in a sharepoint. Now I want to put the source of my report to this dataset in the sharepoint. I created the report in Power BI with the same data...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Clout ,

     

    >>my company doesn't own any own server. Would this function too, if I install the gateway on my local computer to serve as a server?

     

    Yes, only if your own computer can connect to access database in a sharepoint. And you need to keep your computer always on. Or the scheduled refresh will fail.

     

    >>And how would the automatic datarefresh function, if I do this workaround with exporting the access table to sharepoint-list? So I have to export it every time again when I have new data?

     

    Yes, every time you have new data, you should export the Access table to sharepoint list.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Clout ,

 

>>my company doesn't own any own server. Would this function too, if I install the gateway on my local computer to serve as a server?

 

Yes, only if your own computer can connect to access database in a sharepoint. And you need to keep your computer always on. Or the scheduled refresh will fail.

 

>>And how would the automatic datarefresh function, if I do this workaround with exporting the access table to sharepoint-list? So I have to export it every time again when I have new data?

 

Yes, every time you have new data, you should export the Access table to sharepoint list.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai