Forum Discussion

eduardomaia's avatar
eduardomaia
Frequent Visitor
8 years ago
Solved

Web API Connection Stuck on Evaluating

Hi,   I'm trying to create an overview BI with data extracted from Salesforce Objects native integration and with Marketo's Rest API.   After creating all the script for extracting paged data, ge...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    eduardomaia,

    What specific operations(merge/append/add custom columns) do you take in Query Editor? How many rows does your API return and how many queries in Query Editor?


    "If I maintain the queries only on power query and create the connection with the .xlsx file, is it possible to run and update through Power BI? Also, is it possible to load the data model to Power BI Web?"

    Based on the above description, do you want to connect to the data source from Power Query of Excel and update the Excel file via Power BI? If so, it is possible.

    Just make sure you select Add this data to the Data Model when loading data from Power Query to Excel. For more details, please review this article: https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-onedrive



    Regards,
    Lydia

ReportGuru's avatar
ReportGuru
Post Patron
2 years ago

Hi eduardomaiawere you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls 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.