Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Salesforce Objects Power BI Connecter

Hello eveyone

 

I am importing data from Salesforce into Power BI. I noticed that a certain amount of contracts are not imported into Power BI. I can see them on Saleforce, so I would presume that it's not a permission issue. The SF Dev said the same. He also said that all contracts come from the same template. 

 

Does anyone know if there is a restriction on the Salesforce side of things or something to do with a limitation on import to Power BI?

 

Thanks

Joe

  • Anonymous's avatar
    Anonymous
    5 years ago

    I have found the problem. It is a permission issue after all

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have found the problem. It is a permission issue after all

    • amitchandak's avatar
      amitchandak
      Super User

      Anonymous , Can you provide details on how you resolved it? So that others can get benefitted 

  • Anonymous , Can you open the power query and check for any error there?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi amitchandak 

       

      Thanks for getting back to me.

       

      The Power Query is ok as it is importing the majority of the data into Power BI, But when I search for certain accounts, they do not appear in the data that was imported. I tried different tyoes of filtering on the account id and name columns, Using Trim etc.

       

      But unfortunately the accounts cannot be found. 

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, if you are connecting to the reports not the objects there is a limit but i don't recall any limitations on object part.
    if you can get a temp admin access and fetch data with that permissons to cross check you can be sure it is not related to permission. At least this what i have tried when i was working with Salesforce Connector on PBI.