OLE DB: The connection failed because user credentials are needed and Sign-In UI is not allowed.

[travisg_06]

Hello,

I am getting this error when trying to refresh a PBI data set within Excel.  This was working fine for weeks, and it still works fine for several other users, but for me I started getting this error and have found no way to fix it.  I have tried several different things such as clearing local and global permissions in data source settings within Excel, I have tried "Analyze in Excel Updates" that I found buried deep in a google search, and I'm just exhausted with this at this point.

My peers can open the exact same file and do the refresh just fine, I have no clue what to do to fix this.  It's an OLE DB connection string to a Power BI report to get the data into Excel.

[travisg_06]

@Anonymous  right?  So frustrating!  I'm close to tagging every MSFT rep I can in this thread until it gets looked at, this is ridiculous.  I work for a Fortune 500 with major contracts, I can't believe how little attention this is getting.

[Cayshin]

I've discovered a way that resolves the issue for me. In the connection string, remove the sobe_wowvirtualserver- portion.

So for example this:

provider=MSOLAP.8;initial catalog=sobe_wowvirtualserver-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;data source=pbiazure://api.powerbi.com;mdx compatibility=1;safety options=2;mdx missing member mode=Error;identity provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;update isolation level=2

Becomes this:

provider=MSOLAP.8;initial catalog=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;data source=pbiazure://api.powerbi.com;mdx compatibility=1;safety options=2;mdx missing member mode=Error;identity provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;update isolation level=2

Once that was gone and the report replublished, I was able to set up a new Gateway connection

For authenticaiton method, choose Basic, but still enter in your Microsoft credentials.

Power BI will now happily refresh the report.