Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Using data source file with changing name

We use a database at my workplace were everytime you a file is edited and updated to a new version the version number is included in the file name. So if a file is called "SalesPrice 2.5" it will after the update be called "SalesPrice 2.6". So it is only the last part of the name that changes 

 

Is there anyway to to use a path to the file in a way so that the path doesn't die when the name is changed?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous,

I would suggest you use Folder as your source instead of file because you have to provide an absolute path to it. Using Folder as source, you can filter your Name column to include anything that starts with SalesPrice, click on Binary under Content column, then Table under Data column, and perform any other transformation needed. 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@Anonymous,

I would suggest you use Folder as your source instead of file because you have to provide an absolute path to it. Using Folder as source, you can filter your Name column to include anything that starts with SalesPrice, click on Binary under Content column, then Table under Data column, and perform any other transformation needed. 

Anonymous
Not applicable

@Anonymous 

Much appreciated this worked fine.

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.