How to get a new excel data stored in SharePoint into Power BI

[Anonymous]

I have several Excel sheets stored in the SharePoint document library. I can import all of them into Power BI manually using SharePoint Folder source connection, which is smooth sailing at the moment. However, my concern is that these excel sheets won't be the only ones used in the report. That is, a new excel sheet will be added to SharePoint on a monthly basis. My question here is then how do I make sure that the new excel sheet is also loaded into Power BI. Is there any function I can use in power query to confirm whether there is a new excel sheet stored in my SharePoint document library and if so, then combine it with another excel sheet and load it into Power BI? Can anyone please tell me the workaround this? 

[v-kkf-msft]

Hi @Anonymous ,

Unfortunately, the current version cannot realize this idea. It is impossible to change the color of data bars in table visual as the value changes. Please submit your idea.
Ideas (powerbi.com) 

Create a new query in Power Query, copy the M code of the newly added sheet to the new query, and quickly import the newly added sheet.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@Anonymous Not sure I understand - if you're using the SharePoint folder it can pull through all Excel files in that folder, then you can invoke custom function on that folder to get the data from the sheet in each Excel file.

[AllisonKennedy]

@Anonymous 

If you try the Get Data > From Folder you'll see how the combining of files creates a query with parameters, or see my post on parameters in Power Query: Use Parameters to Combine Data