Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a scraped a website and have a table listing funds and daily price. If I refresh this table the prices are replaced with current day prices. I would like to create a table listing funds and add daily prices to it, so the table will grow.
May I ask advice on how I can do this?
Much appreciated,
Kasey
Solved! Go to Solution.
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
Thanks so much for your help!