How to store data in Power BI table using query?

[Iyyanar]

Hello,

Can we pull the data using REST API for every one hour and will save all together in one table to show on report?

[Anonymous · Accepted solution]

Hi @Iyyanar 

Unfortunately Power BI doesn't support that. In Power BI, every time when a query is refreshed, it will load data from the data source and replace the old existing data with the newly got data. It cannot store historical data in the semantic model. This means for a REST API data source, it will only have the data it pulls on the last refresh.

You have to use other tools to pull data from the REST API every hour and store them into a file or database. Then connect Power BI to that file/database to get all data for the report. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[aduguid]

I would use an SSIS integration and store the data in a table in SQL Server.