Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 into Power BI web service.
Since they do not use premium, they have no ability to refresh the data automatically without relying on scripts and excel. This increases the chance of error.
I was wondering if it made more sense to pull the data into a cloud based database using API at set intervals, then direct Power BI to the database to pull the data into the Power BI Web Service.
Do you recommend a cloub based database other than azure or sql server? The company is too small for the large expenses related with premium and azure.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
34 | |
32 | |
25 | |
25 |
User | Count |
---|---|
34 | |
25 | |
23 | |
21 | |
17 |