cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Forbidden from analysis.windows.net in "Analyze in Excel".

How can I fix ERROR - Forbidden from analysis.windows.net in - Analyze in Excel - ?

 

Repro step:

1. Download the odc file by Analyze in Excel on Power BI Service.
2. Open the odc file in Excel 2016.

 

OS: Windows 10 Pro x64.

PC: Surface Pro 4.

Office 365: E3 + Power BI Pro.

 

I want to use Analyze in Excel

 

Regards,

Yoshihiro Kawabata

 

13 REPLIES 13
Highlighted
Advocate II
Advocate II

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

Some other people included me had encountered the same issue. Pending someone to advise

Highlighted
Post Prodigy
Post Prodigy

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

Thank you NH, for information of you and other people's same issue.

 

I'm looking for advise.

 

Regards,

Yoshihiro Kawabata

Highlighted
Regular Visitor

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

I'm also facing the same issue. The error: "The HTTP server returned the following error: Forbidden".

Highlighted
Post Prodigy
Post Prodigy

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

Hi, xstodeepak, thank you for your reply.

 

I'm still facing this issue at 3/29/2016.

 

Regards,

Yoshihiro Kawabata

Highlighted
Advocate II
Advocate II

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

Check out this post "Anyone got the new Analyze in Excel feature working" which has some update from MSBI Taro. But I'm still not able get it work.

Highlighted
Post Prodigy
Post Prodigy

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

Hello, NH, thank you reply

 

I start the Support Request to Office 365 Customer Support.
They are starting to verify this issue.

 

Regards,
Yoshihiro Kawabata

Highlighted
Post Prodigy
Post Prodigy

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

This issue have solved.
I can connect analysis.windows.net for Excel by Microsoft Support's workaroud information.

 

Workaroud is that Add "User ID=<your mail address>" in odc file's before </odc:ConnectionString>.

Just like.

 

  User ID=sample@sample.com</odc:ConnectionString>

 

Now, I can connect from Excel to Power BI Service's Data Model as OLTP server by the odc file.

 

Great Thank you, Microsoft Office 365 Support.

 

Regards,
Yoshihiro Kawabata

 

Highlighted
Helper II
Helper II

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

While the addition of the user name works is this a one time thing or does the user need to add it again and again if they get logged out?

 

 

Post Prodigy
Post Prodigy

Re: Forbidden from analysis.windows.net in "Analyze in Excel".

Hi Kazlik.

 

1. The workaround need to add User ID= ... string to each odc file.

2. At first time to open the odc file by Excel 2016, The user need to sign in operations.

3. No more need to sign in operation, after sign in the odc file, even if close Excel 2016, restart Windows.

 

Regards,

Yoshihiro Kawabata

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors