No me puedo conectar a Informes de Salesforce en Power BI Service

[ygranadc]

Estimados, 

Tengo una puerta de enlace en PBI Service para refrescar los datos. Hace poco agregue como origen "Informes de Salesforce" en Power BI Desktop, agregue las credenciales de mi organizacion y me pude conectar a los datos, sin embargo al publicar el reporte en Power BI Service no me toma las credenciales de acceso, si intento agregarlas en el Service tampoco me toman. ¿Alguna idea de como solucionar esto?, ¿Alguien sabe como agregar Informes Salesforce a una puerta de enlace? Por favor su ayuda.

 

[lbendlin · Accepted solution]

this may help - Saleforce Tutorials (salesforcetutorial.com)

[ygranadc]

Thanks a lot!!!

[lbendlin]

you cannot just use the password. You need to append the security token to the password.

REST API: Security token needed? - Salesforce Developer Community

[ygranadc]

Could you please give me an example how I can do this?

[lbendlin]

Oh, sorry, you are already using the SFDC Reports connector.  Which authentication method did you use on the desktop?

[ygranadc]

And then I use the email and the pass of my organization.

[ygranadc]

Also it says:

The credentials were encrypted with the key stored locally on the gateway server.

[lbendlin]

That's not how you connect to Salesforce.  you can connect to SFDC reports (with the usual 2K row limit) or SFDC Objects (with some rudimentary query folding).  In both cases you will likely need to use basic auth, ot OATH2.

[ygranadc]

It seems to be a problem with my credentials in PBI Service because I have entered it the same way in Desktop but it doesn´t work.

And What type of data I have to select for Salesfor Report?