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

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

Hi, I cannot use "Analyze in Excel", Today.

 

New ERROR happened after update "Analyze in Excel" Program

to Microsoft AS OLE DB Provider for SQL Server 2016 RC3

from Microsoft AS OLE DB Provider for SQL Server 2016 RC0.

 

I tested the odc file, after adding "User ID=.." string on odc file. 

 

Error message may mean "fail to initalize the database", translate from Japanese error message.

1.PNG

I reported it to Microsoft Support.

 

Regards,

Yoshihiro Kawabata

Highlighted
Power BI Team
Power BI Team

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

Hi Yoshihiro-san,

 

I would be happy to assist you and try to debug the issue via Skype call.

My email is tarostok@microsoft.com.

 

Thanks,

Tal

Highlighted
Microsoft
Microsoft

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

Analyze in Excel has now better support for multi users and error scenarios.

 

When you get "Forbidden" and click OK you will get the sign in window

The sign in window enable you to sign in with the user you want.

This replace the ODC user id workaround mentioned here for multi Power BI accounts.

 

ADAL_login.jpg

 

Make sure you have the update RC3 version (on choose "Analyze in Excel updates" and install it)

msolap_rc3_1.PNG

 

 

 

Highlighted
Post Prodigy
Post Prodigy

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

Thank you iIanH, for your information.

 

I'm fix this issue, thank by Microsoft Office 365 Curstomer Support Japan.

 

Fix by: Unintall - and Install.

Step 1. Uninstall Microsoft AS OLE DB Provider for SQL Server 2016 RC3.

Step 2. Install Microsoft AS OLE DB Provider for SQL Server 2016 RC3.

 

Regards,
Yoshihiro Kawabata

 

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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