I am having the same issue. I first see the message: "The HTTP server returned the following error: Forbidden."
I try to connect using my Power BI account, but end up with the message "An operation that uses the database driver could not be completed."
Persist Security Info=True;
MDX Missing Member Mode=Error;
Update Isolation Level=2
So I checked on my other AAD domain joined computer and sure enough that computer worked fine with connection to that power bi domain BUT NOT to my other power bi domain - the same situation I experienced in my previous post.
So here are my questions @tarostok - is the Azure AAD domain join a necessary condition to connect to the service? Also, can we connect to two different domains on the same computer (larger question)? Tal, feel free to contact me as well email@example.com
If you received "Forbidden" error it should not be related to the data, Excel SQL etc.
Did you get "Forbidden"?
If the answer to the above is yes, when you opened the downloaded ODC file, did you get AAD sign-in window?
A question and a possible solution for those who got "Forbidden" error:
When you opened the ODC file did you get AAD sign-in window (see picture below)?
If the answer is no please try the following solution:
1. Open your ODC file in notepad.
2. Inside <odc:ConnectionString> tag add the following property: ;User ID= your PowerBI user name;
3. Save the ODC file.
4. Open it in Excel.
Now you should get the AAD sign-in window and successfully log-in.
Highly appreciate your feedback.
I have tried what you recommendation but I still get the same forbidden error. THen I get this popup (same as always happens) however now my username is pre-popluated (it was not like this previously). The Password box was blank. I enter my password (shown below)
Then I get this error shown below.
... when you opened the downloaded ODC file, did you get AAD sign-in window?
In my case, the first time I did this I got some Power BI authenticaion window - I believe it looked like the one you posted. It failed on login, then from then on I always get the forbidden error followed by the SSAS login window.
I tried to clear the credentials on my PC to get the first login page back, but that was no successful
Not familiar with ODC script. Thus need your advise is the below script to include the User ID in ODC file is correct? I'm still not able to the AAD sign-in windows prompt. Note: I'm on Free Power BI version.
</odc:ConnectionString ="User ID = PowerBI user name">
sorry I've entered the User ID = BI account name at the wrong place. Corrected as shown but still no AAD prompted.
<odc:ConnectionString>Provider=MSOLAP.7;User ID= BI account name; .....
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.