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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Moh_ali_square
Advocate I
Advocate I

Power BI Template for Excel files using file location as a parameter

Hi, 

 

I am doing periodical reports right now on excel file extracted from a Database and other sources. I need to have a template to be used every month, qurder or year with a reference to new excel file. I have those files stored on a shared drive.

my question, how to make the excel file location as a parmeter, so every time I open a template, it asks me about file locations?

Thanks.

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @Moh_ali_square,

 

In your scenario, you can use Query Parameter to pass dynamic Excel path. See: Power BI Desktop Query Parameters, Part 1.

 

q2.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

Hi @Moh_ali_square,

 

In your scenario, you can use Query Parameter to pass dynamic Excel path. See: Power BI Desktop Query Parameters, Part 1.

 

q2.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-qiuyu-msft Thank you for your reply, I tried it. but it is asking for an absolute path not a paramter. so I can't change the absoule path to a paramter with this way. 

is there any other way to include the Excel workbook path as a paramter?

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors