Mar 26 2021 03:02 AM
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?
Mar 26 2021 05:32 AM
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.
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)
Mar 26 2021 07:31 AM
Mar 30 2021 01:20 AM
Mar 30 2021 05:16 AM
Here are a few additional links with instructions.
Hope these will help you.
Nikolino
Sep 08 2021 08:11 AM
Sep 09 2021 06:35 AM