Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey Everyone
I am trying to generate email for admins with links to dynamically generated PowerBI reports using report URL filter for each computer in a excel list.
The link works great if I Type/Copy paste it, but if I open from Excel by clicking the URL, then PowerBI sends me to the front page.
Other links works great from excel, it is only PowerBI links (afaik) that fails.
It seems VERY weird
The report link is similar to :
When URl is opened from Excel, I am redirected to:
it requests logon, and after logon I am sent to my front page.
(logon is usually working as single sign on for this browser.)
I have tried Chrome and IE.
So I suspected something about weird characters, so I shorten the URl using goo.gl:
to make the url similar to:
But it does the name! .. works if I Paste, redirect if I click.
I am not sure where this error is, but as it is only PowerBI links that does not work I posted it here.
Does anyone know what happens and how I can link to a PowerBI report from an excel sheet?
Thanks!
Hi
I found that the best way was to copy your report URL into Excel as normal, click it from Excel and it will open with a sign in page, click sign in which takes you back to the report but this time copy the URL in teh address bar and use that as your Excel report URL. The URL normally ends in check=1 from my experience but maybe different and if it works for you then hey go with it. One day MS wil make their products work together 🙂
This worked like a charm. Thank you.
HI @JakobGsvendsen,
According to your description, I think this issue more related to excel.(open power bi url stored in excel)
Maybe you can try to contact to excel team to get further support.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.