Forum Discussion
Hyperlinks with a filter going from Excel to Power BI report
Hi, I'm new to this community
I'm using Microsoft 365 Apps for enterprise with Excel version 2008
I have build a hyperlink from Excel to a Power BI report (PBI), which works.
=HYPERLINKS("PBI_URL&noSignUpCheck=1";"Test 1")
The problem starts when I'm trying to add a paramter (filter functionality)
=HYPERLINKS("PBI_URL?filter=TableName/FieldName eq 'OrganizationalNumber'&noSignUpCheck=1";"Test 2")
The URL takes me to Power BI, but it does not trigger the filter . If I copy the same link into the browser it works fine. It seems that the HYPERLINK formula in Excel does not exept filter funsctionality.
How can I build the hyperlink in Excel so that it takes me to a filtered Power Bi report?
7 Replies
My knowledge of Power BI is very limited.
But that doesn't stop me from sending you these links from Microsoft where you might find a way to go.
Data refresh in Power BI
Common issues and resolutions for Power Apps
Tips and tricks for creating reports in Power BI Desktop
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- Thank you for your respons, but I do not think the problem is in Power BI. The problem is how to add the hyperlink with a functional filter in Excel. It seems like Excel is not able use the URL with a filter. Do I have to write a VBA code for it to work and do you have an example code I can use?
