Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Script Error Occurs When Connecting Power BI to Salesforce

Someone on my team is trying to connect Power BI to Salesforce reports. We he tries to login to Salesforce using a shared login he gets the following script error.

An error has occurred in the script on this page

Line:22

Char:3698

Error:Unable to get property 'useldp' of undefined or null reference

 

 

Is there anyway to correct this? It works fine for me.

Need Help

5 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    10 years ago

    Anonymous

     

    Are you using the same shared login account and same latest version of Power BI Desktop? Since you can connect to the same Salesforce reports successfully, it seems that there is no problem both on Power BI and Salesforce side. Maybe you can let him try to uninstall and reinstall Power BI Desktop to see if it will work.

     

    Best Regards,

    Herbert

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Yes we are using the same shared login and version of Power BI.  We tried uninstalling and still were not able to sign in to update the data when we reinstalled.

      • v-haibl-msft's avatar
        v-haibl-msft
        Microsoft Employee
        9 years ago

        Anonymous

         

        Could you please take a look at this thread? Someone got the same error message as you and has found the cause of it.

        Maybe you can try the same solution to see if it also works for you.

         

        Best Regards,

        Herbert

  • ReportMaster's avatar
    ReportMaster
    Post Partisan
    1 year ago

    Hi, as a workaround, maybe you can try to test your connection with a 3rd party connector. 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. 

     

  • metrica's avatar
    metrica
    Post Prodigy
    22 days ago

    The thread never confirmed the root cause. Current Power BI Desktop versions use Edge WebView2 for Salesforce OAuth.

     

    I would update Power BI Desktop and WebView2, clear the saved Salesforce permissions, and reconnect.

     

    Power BI Connector for Salesforce is another option. Power BI refresh uses a personal access token and OData source rather than the Salesforce OAuth login dialog.

     

    AppExchange and 30-day trial:
    https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577