Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

travisg_06

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

Submitted by on ‎01-18-2023 07:36 AM

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.

Status: Needs Info
See more ideas labeled with:
12 Comments (12 New)
Comments
Anonymous
Not applicable
‎01-18-2023 11:38 PM

Hi @travisg_06 

This issue only happened to you ? Your colleagues can refresh dataset in the same excel ? Did you try to sign in your account in their computers ? Or you can ask your colleagues to log in to their accounts on your computer to test and determine whether it is a client problem or an account problem .

 

Best Regards,
Community Support Team _ Ailsa Tao

travisg_06
Regular Visitor
‎01-19-2023 06:27 AM

That is not possible to do, we are all remote workers in different states.

travisg_06
Regular Visitor
‎01-19-2023 06:36 AM

This user describes the same issue in a different forum 2 days ago:  OLE DB: The connection failed because user credent... - Microsoft Power BI Community

 

Is there a way to enable the sign-in ui?  Why is it not allowed?  There is no clear solution to this, and I have been searching the web for answers for days.

travisg_06
Regular Visitor
‎01-23-2023 10:52 AM

Bump...

Anonymous
Not applicable
‎02-22-2023 04:12 AM

This issue has now been bothering me for more than a month. The issue happens with no discernable pattern and bothers others as well. Can someone please examine why it happens? 

travisg_06
Regular Visitor
‎02-22-2023 06:25 AM

Yeah, why is this getting absolutely no support or follow up?

travisg_06
Regular Visitor
‎02-22-2023 06:26 AM

@Anonymous please follow up and read replies from others.

travisg_06
Regular Visitor
‎06-07-2023 06:46 AM

@Anonymous this issue has now spread to all users on my team.  This is a major problem that no one is addressing.  PLEASE HELP!

travisg_06
Regular Visitor
‎06-07-2023 06:47 AM

@Anonymous did you ever get this resolved either?

Anonymous
Not applicable
‎06-07-2023 12:04 PM

Hi @travisg_06, I did not manage to get this fixed. I have been checking periodically for updates but there seems to be no interest at Microsoft in fixing this issue. Maybe they were the ones blocking this form of access to PBI data models. I would be glad to be proven wrong of course.

 

My solution has been to have my administrator make dataflows for every table in the data model I was trying to copy. Feels very inefficient, but it works if you have that option as well. We really need a way to import a PBI data model directly into another dashboard without being limited to DQ. Until then this will have to do I guess.

Idea Statuses