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

[Shruthi96]

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 sharepoint , and the new data file should be appended to Power BI desktop. 

File will be replaced in the sharepoint with the same file name and it should be appended in the Power BI desktop on daily basis. 

My input file will be new with the same file name, but in the Power BI it should get appended on daily basis. 

Let me know if there is solution for this issue. 

[Shruthi96]

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]

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.