Forum Discussion

10500438's avatar
10500438
Icon for Helper II rankHelper II
6 years ago

Best database option for small business

I have a client who uses a Rest API to retrieve data from their corporate database, currently they pull the data down and into excel, using Power query to massage the data, and push the data back int...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  10500438 

For your requirement, you don't want azure or sql server, I would suggest you use Excel as  the datasouce, then you could also upload it to onedrive or sharepoint. 

Now you could get data in power bi and set Scheduled refresh for this datasource. This does not need premium.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

Regards,

Lin