question

RustyBenson-1535 avatar image
0 Votes"
RustyBenson-1535 asked Viorel-1 answered

Hyperlinking from an Excel activeX Button to a PowerBI report/dashboard???

Is it possible to have an activeX button on an Excel sheet that when clicked, redirects you to a PowerBI dashboard?

I have the VBA code to hyperlink out of Excel to a specified URL, but I am not quite sure how the URL system for PowerBI reports works. If this is possible, can you also send parameters to automatically filter the dashboard?

office-vba-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
Based on your description, I add the tag office-vba-dev, you can get more help about Office for develop, the reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

0 Votes 0 ·

1 Answer

Viorel-1 avatar image
0 Votes"
Viorel-1 answered

If the files have some specific extensions, then try the Shell object, specifying the path to the file, including extension, for example:

 Dim s
 Set s = CreateObject("Shell.Application")
 s.Open "C:\MyFiles\MyReport1.pbix"

Do it inside the handler of the button.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.