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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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