Forum Discussion

Shruthi96's avatar
Shruthi96
Helper III
6 years ago

Data flow to Power BI Desktop/Power App (sharepoint data source)

Hi All,    Need help..!   I get new daily report from sharepoint documents, this sharepoint document is connected to Power BI desktop as data input.    Daily report file will be replaced in the...
Dataflow
Need Help
Shruthi96's avatar
Shruthi96
Helper III
6 years ago

Hi All, 

 

Missed to provide one more input. 

 

Currently entire data set is replaced in Power BI, but it should be appened to yesterday report. 

 

Let me know if there is solution. 

nickyvv's avatar
nickyvv
Most Valuable Professional
6 years ago

Hi Shruthi96,

Not sure if this will work, but you could try to:

  • Duplicate the query you have in Power Query to query 2
  • Then Append the query 2 to the original query?
  • Depending on if you get any circular reference errors: disable load on query 2. That will automatically be loaded when you refresh the original query.

Let me know if that helps.