Forum Discussion

Stanford08's avatar
Stanford08
Frequent Visitor
3 years ago

Automatically importing, into PBI, a SharePoint file with a changing file name.

Hi there


How do i automatically import, into PBI, a SharePoint file whose last portion of the file name is changing. 

eg. 

 

File-10022023

File-09022023

 

Thank you and regards

 

Stan 

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Always use the Sharepoint Folder connector, never the File or Web connector.  That way your Power Query code can handle file name changes.