Reply
Frequent Visitor
Posts: 2
Registered: ‎12-09-2016
Accepted Solution

Personal gateway credentials issue

Hi,

 

I am using the Trial version of power BI Pro and have installed the personal gateway in order to connect to an on premises data source.

 

After installing the gateway, in power BI it is mentionned "Online" under Gateway connection in the dataset configuration.

 

But when I try to refresh the data, it says "The credentials stored in the cloud are missing".

 

So I saw a previous post where the solution was to re-enter the credentials in power BI.

 

But the issue I'm facing is that the link to edit the credentials is missing in Power BI cloud.

 

Do you know what might be causing this problem?

 

Thanks in advance for your help,

 

poweBI.jpg

Omar


Accepted Solutions
Frequent Visitor
Posts: 2
Registered: ‎12-09-2016

Re: Personal gateway credentials issue

Hi Guys,

 

Thanks for your input and your support regarding this issue.

 

It seems that Microsoft has corrected this issue last night: the Edit credentials link is now available again!!

 

Best regards,

 

Omar

View solution in original post


All Replies
Super Contributor
Posts: 2,193
Registered: ‎06-25-2015

Re: Personal gateway credentials issue

@obaechtiger I have had this same issue. I noticed it yesterday with a new dataset I uploaded. Just a simple excel file for testing and I was unable to refresh. I updated by personal gateway, stopped the service, started the service and redeployed the PBIX mulitple times. I see the same behavior you describe below.

There is an error warning on the power bi support site, but it only references SharePoint as a data source...

Looks like I'm in a different region as well 

 

errorJPG.JPG

 

Near SE WI? Join our PUG MSBIWI
Highlighted
Member
Posts: 61
Registered: ‎04-11-2016

Re: Personal gateway credentials issue

I've been having the same issue since yesterday morning. Very sad Smiley Sad

Super Contributor
Posts: 2,193
Registered: ‎06-25-2015

Re: Personal gateway credentials issue

@dsutt519@obaechtiger I've created an issue with link to this thread. Throw your "votes" on it here

Near SE WI? Join our PUG MSBIWI
Frequent Visitor
Posts: 4
Registered: ‎12-09-2016

Re: Personal gateway credentials issue

@Eno1978@obaechtiger@dsutt519

I'm facing the excact same issue. My datasets has been working ok until earlier today ago where I re-published a dataset with som minor changes. When I try to refresh in the Power BI Service, I get the same error "The credentials stored in the cloud is missing". The 'Data Source Credentials' section is complete wiped out, so I am not able to update any of the credentials.

 

1) The Personal Data Gateway is running fine. 2) I have tried deleting and re-publishing the PBIX file again without any luck.
For information my dataset consist of an SQL-server in AWS  and Onedrive for Business files.

 

I am in general very pleased with the Power Bi Dektop experience... but I must admid that trying to schedule a stable refresh i Power BI Service is close to a nightmare. I hope Microsoft will be able to improve this part of Power BI.

 

Best regards,

Torben

Frequent Visitor
Posts: 2
Registered: ‎12-11-2016

Re: Personal gateway credentials issue

I had same issue. Hope MS will fix this ASAP. Nightmare!

Member
Posts: 61
Registered: ‎04-11-2016

Re: Personal gateway credentials issue

Please fix!! Why would it just stop working all of a sudeen! So sad.

Regular Visitor
Posts: 26
Registered: ‎03-07-2016

Re: Personal gateway credentials issue

I've updated the credentials in the Power BI Desktop file, and now after publishing I am not able to edit credentials in the cloud. I see the same blank section under data source credentials that you see! What's going on???

Member
Posts: 61
Registered: ‎04-11-2016

Re: Personal gateway credentials issue

This is day #5 and Microsoft has not yet fixed this issue! Seems like with as many people using PBI this issue should have been fixed by now! Very sad.

 

Regular Visitor
Posts: 26
Registered: ‎03-07-2016

Re: Personal gateway credentials issue

I tried a the following:

 

* Deleting the data sets in Power BI and republishing

* Changing the name of the Power BI desktop file and republishing

 

But couldn't get it to work. Finally I created a new Power BI desktop file and imported the same data source. After publishing it, when trying to refresh that dataset I was asked for credentials in the Power BI service. At that point, the old data sets started refreshing. HOWEVER, they still don't have the option to change their credentials in the Power BI service. The data source credentials section is still blank!

 

Very frustrating not to understnad how or why this is happening.