Making changes in URL with filter

[Lars-6]

Hi, 

I am working from a company, and recently they wanted to begin with Power BI. I was asked to do this. I am completely new to power BI, but managed to figure most things out. only for one thing not. this is my situation: 

for my invoices we use a program that has a URL to get data. lets say the url is: https://company/get/v6/invoices/2025001  2025001 is the invoice ID. this works perfectly with power BI, and I get the data of this project. but in my setup I have a filter for the client where he can put in the invoice ID for the project that he wants to see the data from. now comes my question, how is it possible to change the invoice ID in the URL using the input from my filter. for example, when I set my filter to: 2025010 my url becomes https://company/get/v6/invoices/2025010 then the correct project info gets pulled in. 
I have also tried if I can get a range of invoice ID's so that I dont have to deal with this, but the URL doesn't allow that. 

anybody has any idea? 

already thanks!

Lars 

[v-mdharahman · Accepted solution]

Hi @Lars-6,

Thanks for reaching out to the Microsoft fabric community forum.

Based on what you've described, it looks like you're using a web API that returns data for a single invoice ID at a time, and you're hoping to let report viewers enter or select an invoice ID from a slicer, which would then update the URL and pull in the relevant data dynamically. This is a common question, and I want to clarify how Power BI works in this area.

In Power BI, slicers and filters only work on data that’s already loaded into the report. They can’t be used to change the query or URL that’s used to fetch the data in the first place. Since you're using a URL like "https://company/get/v6/invoices/2025001", the 2025001 part is hardcoded when Power BI runs the query, and it doesn’t respond to changes from a slicer.

That’s why even though you can create a parameter and use it in the URL in Power Query using the Advanced Editor or GUI, it won’t dynamically change based on slicer input during report viewing.

To make this work as expected, here are two possible appoaches which you can follow:

* You can manually define a parameter in Power Query for the invoice ID and use that in your URL. Each time you

   want to change the invoice, you’d update the parameter and refresh the data. This can be useful during

   development or if only a few people are using the report.

* If your API ever supports querying a list of invoices (e.g. by date range or customer), that would be ideal. You

   could pull all needed invoice data into Power BI once, and then use slicers/filters as you intended because the

   data would already be there.

Right now this is the only way possible and it’s not the perfect solution, but Power BI doesn’t currently support dynamic API calls based on user input during report interaction.

I would also take a moment to thank @vanessafvg, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[v-mdharahman]

Hi @Lars-6,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[v-mdharahman]

Hi @Lars-6,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.

Thank you.

[v-mdharahman]

Hi @Lars-6,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[vanessafvg]

I would duplicate the URL column and then split out the invoice number from it, and then let the user search on that column...   then you can set up a slicer than you can search on and the user can search for that data bringing back that record.   when they want to change it to another they can search using the slicer.  

[Lars-6]

Hi, 

where do I put the URL and invoice number column? is it in the file it self, or do I need to put in in the advanced editor? 

[vanessafvg]

you can just right click on the column and duplicate it in the gui.  if you p[rovide some sample data i can do it for you and show you how.

[Lars-6]

Hi, that would be great! this is the data that I get returned from the url: 

RB_UID	INVOICE_ID	INVOICE_PRICE	RELATION	DATE_FROM	DATE_TO
1	2025001	€510,50	Customer1	2025-01-01	2025-01-30

I have used this ulr to get the data from a web api: https://company/get/v6/invoices/2025001

of course this is an example without the real data of the company😅. but I hope you get the point.

[Lars-6]

Hi! ofcoarse, this is the data that I get returned from the url: 

RB_UID	INVOICE_ID	INVOICE_PRICE	RELATION	DATE_FROM	DATE_TO
1	2025001	€510,50	Customer1	2025-01-01	2025-01-30

I have used this ulr to get the data from a web api: https://company/get/v6/invoices/2025001

of course this is an example without the real data of the company😅. but I hope you get the point.