12-09-2016 06:35 AM
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,
Solved! Go to Solution.
12-15-2016 01:03 AM
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!!
12-09-2016 07:27 AM
@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
12-09-2016 11:42 AM
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.
12-12-2016 05:35 PM
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???
12-13-2016 09:41 AM
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.