Power BI have functionality to pick automatically if new file available in the share point folder

[Anonymous]

I have two sets of files (A and B).
Each A and B file appended with year like A_2018,A_2019,B_2018,B_2019.

A file has different columns and B file has different columns. Now my query is, do Power BI have the functionality to pick automatically if A_2020 file available in the share point folder?

[Greg_Deckler]

OK, thought question was going a different route. What do you mean by pick automatically?

[Anonymous]

First time we will append all the data respective to A and B file then load into single table for each file.  

If buiness user place  A and B new files for next year in seperate spreadsheet then Power BI have to identify the respective file name and append new file data with exisiting data automatically.

[rainer1]

Hi @Anonymous,

there is no solution for your purpose of automatically loading new files to power bi. Because of the fact you specifiy the data file name when you add a new source.

Parameters may be a solution - See here https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

The problem with parameters is you will override the the file name so the complete table will change based on the parameter.

-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!