Forum Discussion

alanandersen1963's avatar
alanandersen1963
Copper Contributor
Mar 26, 2021

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("PB...
excel
Formulas and Functions
alanandersen1963's avatar
alanandersen1963
Copper Contributor
Mar 26, 2021
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?
  • alanandersen1963's avatar
    alanandersen1963
    Copper Contributor
    Mar 30, 2021
    Hi and thank you for your help, but I'm not able to get it to work.

    The hyperlink with the filter works from Edge and WordPad, but not from Excel or Word. I want to click a hyperlink and open a filtered Power BI report.

    Why du I need this, I have several users useing Excel and not looking into details which they find in Power BI. Therefore am I trying to build the hyperlink so that they can go from a cell (hyperlink) in Excel and find the details in Power BI.

    The filtered link works when I'm copying it into the browser manually or triggering it from WordPad, but not from Excel or Word, why??

Resources