cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cpgbi Frequent Visitor
Frequent Visitor

Data source **** is missing credentials...

When one of the three of us on PBI Pro uses desktop to publish a report we can’t access it, including the creator. But if the report is emailed to me I can publish it just fine. In app.powerbi I can go to the dataset and “take over” and then everything is fine. The creator sees a message saying it can’t be refreshed because the credentials are invalid when going into app.powerbi to see the dataset. It feel like blowing away her account and then recreating it and starting over. Any thoughts?
4 REPLIES 4
Community Support Team
Community Support Team

Re: Data source **** is missing credentials...

Hi @Cpgbi 

 

What do you mean" But if the report is emailed to me I can publish it just fine", Not quite understand your scenario, could you please share more details with screenshots?

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Cpgbi Frequent Visitor
Frequent Visitor

Re: Data source **** is missing credentials...

Screenshots I cannot post unfortunately. What happens is one of the three of us with a PBI Pro login and has access to the particular workspace can download, edit, etc. she gets the data source error when publishing. But if she sends to me and I open and publish it works fine. I compared settings everywhere I could find and it seems everything is exactly the same. But there has to be a setting I’m unaware of that is stripping the credentials when she publishes. So this is different than the similar error people have seen regarding refreshes.
Community Support Team
Community Support Team

Re: Data source **** is missing credentials...

Hi @Cpgbi 

 

1. If publish from the Desktop is not working, try to connect to the data from the Power BI Site. 

Get Data -> Files (Get) -> Local Files -> find your PBIX file on local drive.

2.   Make sure she has the role of power bi service administrator. you can check it in 365 admin portal.

0003.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Community Support Team
Community Support Team

Re: Data source **** is missing credentials...

Hi @Cpgbi 

 

I came up with new thoughts about this question, you mentioned that "it can’t be refreshed because the credentials are invalid when going into app.powerbi to see the dataset", the error typically happens when the credentials of the dataset been changed. 

You can do a test on the desktop, connect to the data source and manually refresh it, if it failed, please clear the datasource setting and relogin. 

 

If it still doesn't work, please kindly share the error details when "she gets the data source error when publishing."

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,342)