Forum Discussion

rs's avatar
rs
New Member
8 years ago

Data source credential disabled - Powerbi online version

Power BI version - Online 

Issue - Data source Credentials (Disabled)

Data Set - All connect to salesforce

 

Notes:

The credentials for the dataset has not changed for some time and online version of BI was working without any issue previously.  However, it stopped working and does not allow to reset the credential. Please advise how to resolve this issue. 

 

Error Details:

data source credential disabled

Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

 

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.

Data source errorAuthentication error, could not get Token. CPEX[|{"ErrorCode":"PersonalGateway_ShortMessage_DataSource_InvalidCredential","ExceptionCulprit":1,"IsPermanent":true,"Message":"Authentication error, could not get Token"}|];Rest Api call failed after 7 retries. The remote server returned an error: (400) Bad Request.. The exception was raised by the IDbCommand interface.
Cluster URIWABI-US-EAST2-redirect.analysis.windows.net
Activity IDf2b3fdce-36ba-488a-b07e-996b8e243f57
Request IDabb068c1-1c54-81f6-e19b-80828b89e84a
Time2017-11-06 14:28:03Z

 

 

 

 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    When was the last time you updated your Gateway?  I'm wondering if your Gateway is out of date.  They recently disabled some of the older technologies that had some security flaws.  My expectation would be that some users, if they haven't updated, would get locked out.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi rs,

     

    In addition, have you tried downloading the pbix file on Power BI service, then try refreshing it with Power BI Desktop. If refresh works on Power BI Desktop, you can try removing the whole dataset on Power BI service, then republish the reports from Power BI Desktop to see if it fix the issue? :smileyhappy:

     

    Regards

  • ReportRanger's avatar
    ReportRanger
    Icon for Helper III rankHelper III
    2 years ago

    Hi rs were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which does not require a gateway because it pulls the data directly from SF objects API. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

     

     

    After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

     

     

    There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.