Forum Discussion

toussdev's avatar
toussdev
Frequent Visitor
2 years ago

Salesforce connexion to Power Bi Service

hi i have just published a new report on PBI service. This report uses connexion with Salesforce Object. It works perfectly on PBI desktop. But on PBI service, impossible to set up a connexion. the w...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Dataflow is an online Power Query

 

According to the screenshot you are not able to connect with your credentials

 

My guesing is that the report which is connected in the service is using a Service account to connect to Salesforce. Il faut verfier avec tes Admins Salesforce et Power BI Tenant.

 

toussdev's avatar
toussdev
Frequent Visitor
2 years ago

aj1973 i done yet that yesterday but it doesn't fix my problem. 

 

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Vraimen bizzare !, You can connect online which is good,

    Did you connect here in your desktop?

     

  • toussdev's avatar
    toussdev
    Frequent Visitor
    2 years ago

    yes, aj1973 exactly! thanks for your help, Amine!!

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Welcome,

    Can you please show me you the M code in Query Editor?

    Also the steps applied please

  • toussdev's avatar
    toussdev
    Frequent Visitor
    2 years ago

    the code for the connection? it's classic; 

    = Salesforce.Data("https://login.salesforce.com/", [ApiVersion=48])

    and after = Source{[Name="Account"]}[Data]

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Check this out

     

    Compare the Version of the one report that is connected and refreshes fine.