Forum Discussion

Iyyanar's avatar
Iyyanar
New Member
2 years ago
Solved

How to store data in Power BI table using query?

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?
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!