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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bbarth
Helper I
Helper I

Template file (.pbit) using a parameter to have user input folder as data source

I have created a report I need to use as a .pbit file. I have set up a parameter so that the user can enter the folder path to update the data source for the report. The reason I need to use a folder and not a file is that each user will have multiple files, varying names, and varying number of files that need to be included in the report. I have it set so that the query appends each of the files so it doesn't matter how many files they have or what the name of the file is. Each of their files will have the same layout so that is not an issue either. I was able to create the .pbix file just fine. The problem comes when I save the file as a .pbit. When I open the .pbit file and input my folder path if I do not have all the same files with the exact same names then it gives an error saying it can't find the file. Any ideas?

 

Thank you in advance.

1 ACCEPTED SOLUTION
nandukrishnavs
Super User
Super User

@bbarth 

 

Maybe in your actual PowerQuery, there is a reference for files. Example filenames are hardcoded.

Check your PQ in the advanced editor.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

View solution in original post

2 REPLIES 2
nandukrishnavs
Super User
Super User

@bbarth 

 

Maybe in your actual PowerQuery, there is a reference for files. Example filenames are hardcoded.

Check your PQ in the advanced editor.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos
🙂


Regards,
Nandu Krishna

Thank you, you are a genius! I can't believe I missed something so simple. I appreciate the help.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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