cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anne_van_hal Occasional Visitor
Occasional Visitor

Credentials are invalid public cloud Sharepoint online-PowerBI.com connection

I get this message trying to connect from powerbi.com dashboard to my public cloud sharepoint online list.:
"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." 
I can try to reconnect (OAuth2) but it keeps giving this message.  The people that I granted access to my Dashboard can see my dashboard though. But of course I try to achieve an hourly automated update of the report. and for that I need the credentials.

I searched the internet and I searched this community and it seems many more people have similar problems.   Since I connect from public cloud to SharePoint online I should not use a gateway and should be able to enter my credentials and schedule a report refresh.  but I can't.

Is there anybody who has a solution? (I already re-installed my PowerBI desktop with the latest version and republished my dashboard to powerbi.com).  Or Microsoft? If this is a defect in the tool, is there a planning when we can expect to have a solution for this?

thanks in advance for thinking along!

 

5 REPLIES 5
ttinsley Regular Visitor
Regular Visitor

Re: Credentials are invalid public cloud Sharepoint online-PowerBI.com connection

I am having the same issue

Cuttyson Frequent Visitor
Frequent Visitor

Re: Credentials are invalid public cloud Sharepoint online-PowerBI.com connection

Similar issue except I'm using an Excel spreadsheet that is stored in a SharePoint Online document repository.  When I did the initial Get Data to access the spreadsheet, I had a hiccup with either SharePoint or PowerBI inserting a "@SSL" into the file path - which prevented its upload, but when I deleted the "@SLL" from the filepath, I was able to bring in the data just fine.  People I have share the dashboards with can also see the visualizations just fine.  Now I go to schedule a daily refresh and it says my credentials are invalid.  In this case, it's using Windows credentials and I'm still logged in as the original Windows user I was at the beginning, so this is making no sense to me.

 

Having said that, I'm logged into a preview version of a PowerBI using different PowerBI credentials than my Windows credentials.  Could this be the problem?  If so, then why was I able to get the data in the first place?

gabriam Occasional Visitor
Occasional Visitor

Re: Credentials are invalid public cloud Sharepoint online-PowerBI.com connection

Same trouble here. Is it solved?

Cuttyson Frequent Visitor
Frequent Visitor

Re: Credentials are invalid public cloud Sharepoint online-PowerBI.com connection

No solution yet.  I finally engaged with PowerBI support and literally just finished sending them a Steps Recorder session and a Fiddler trace.   I'll post anything relevant that comes out of my interactions with them.

Cuttyson Frequent Visitor
Frequent Visitor

Re: Credentials are invalid public cloud Sharepoint online-PowerBI.com connection

At least in my case, the issue was that my organization is using the government version of SharePoint online and - until recently - there was no government version of PowerBI.  The could not see the other given the government versin of SharePoint Online is more finicky about data sharing/access.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 311 members 3,323 guests
Please welcome our newest community members: