Forum Discussion
Daily share price table
It's not so easy.
One approach is outlined in: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
An alternative would be - if possible for you - to use Excel with Power Query:
First: create a query with output to a table in Excel with the initial data, let's call it FundsAndDailyPrices.
Next: adjust this query to get new data from the web, append it to FundsAndDailyPrices, remove duplicates and export the result back to table FundsAndDailyPrices.
This is a so called self referencing query, as (part of) the input is from the same table as the output (FundsAndDailyPrices).
It is not really self referencing, as the query doesn't reference itself, but the table in Excel, which are different objects,Now you can use the Excel file as input for Power BI Desktop.
Notice that any data refreshes should be done both in Excel AND in Power BI Desktop (in this sequence).
It's not so easy.
One approach is outlined in: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
An alternative would be - if possible for you - to use Excel with Power Query:
First: create a query with output to a table in Excel with the initial data, let's call it FundsAndDailyPrices.
Next: adjust this query to get new data from the web, append it to FundsAndDailyPrices, remove duplicates and export the result back to table FundsAndDailyPrices.
This is a so called self referencing query, as (part of) the input is from the same table as the output (FundsAndDailyPrices).
It is not really self referencing, as the query doesn't reference itself, but the table in Excel, which are different objects,
Now you can use the Excel file as input for Power BI Desktop.
Notice that any data refreshes should be done both in Excel AND in Power BI Desktop (in this sequence).
I didn't think it would be straight forward :mansad:
Thanks so much for your help!
