Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

PowerBI API Integration

Issue: We publish monthly reports in Microsoft Power BI, featuring historical data visualized through graphs and charts. Our current Power BI file includes data extracted from an Excel file up to Sep...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Anonymous 

     

    Power BI reads the data at refresh time and doesn't store its historical version. Even if you buffer it in a separate query and  choose not to load it, that query will still be evaluated if referenced by other loaded queries. If you want to include October data and not be pulled from API in the next refresh, you must use an external storage (excel, dataflow, another database, etc) and then append that in the query editor.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

 

Power BI reads the data at refresh time and doesn't store its historical version. Even if you buffer it in a separate query and  choose not to load it, that query will still be evaluated if referenced by other loaded queries. If you want to include October data and not be pulled from API in the next refresh, you must use an external storage (excel, dataflow, another database, etc) and then append that in the query editor.