Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |