My data lives in Salesforce objects and I am trying to connect Power Query to Salesforce Objects. The limitation here is that I have to extract the whole object and then filter the required fields. Is there an option to direct query salesforce object without having to extract the object.
Is there a way to direct query Salesforce Objects to Power Query/Power BI without having to extract the object
2.1k Views Asked by Priyason Pauldurai At
2
There are 2 best solutions below
Related Questions in POWERBI
- Embedding Microsoft Power BI into Liferay
- PowerBI hierarchy creation without the cloud
- How to create nested tiles in Power View
- BI Designer many to many relationship
- Microsoft Power BI Designer data model to Excel or PowerPivot
- How to link table row content to source in Power View
- Stream Analytic to PowerBI complains about PowerBIOutputAdapterTransientError
- How can I connect datasets from machine learning to SQL database in Azure?
- drilling from powerbi to ssrs
- How do you connect an Azure Table Storage with Power BI through Stream Analytics?
- Power BI Line Chart Getting Confused
- Handle blank value in Complex expression IF condition in PowerBi
- Power BI running total measure not working when no data for dimension
- Periods to Date Calculation MDX
- Loop on M query
Related Questions in SALESFORCE
- Flask-Restful, oauth, and Salesforce
- i am using Command line dataloader in Salesforce & create simple “process-conf.xml” file ,i want to give relative path insted of absolute path
- VBA automation to upload data into Salesforce
- "Operation in progress..." Never Ends When Previewing Rows in Kettle Spoon via Salesforce
- How to download attachments using c#
- Opportunity Field Dependency
- Create a dynamic SOQL Query using variable objects
- Salesforce - HubSpot API calls
- When does Time Dependent workflow rule executes?
- Customize 'Send with Docusign' Button in Salesforce
- How do I use a publicly hosted image as the background for a visualforce page?
- How to get access token and make salesforce rest api requests with paw?
- List button in Salesforce1
- Visualforce page is not refreshing after deleting a row from table
- Docusign Salesforce Logout/switch account
Related Questions in POWERQUERY
- How to create nested tiles in Power View
- excel power pivot and power query
- How to link table row content to source in Power View
- Excel Data Imported as '15/2, Macro to convert to number?
- Power query function optional arguments
- Power Query for Excel
- Loop on M query
- Connecting SAS Datasets with Power Query
- Power query - Calculated column to check date
- Powerquery: how to import multiple text files from a folder in separate columns in the same excel sheet
- Groupby in MS Power Query/Power BI for specific values
- Excel power query connection with DB2
- Function to generate list of dates
- Excel VBA Power Query Task Scheduler Open
- Consolidating multiple tables from different workbooks with same fields into one table using PowerPivot
Related Questions in SALESFORCE-EINSTEIN
- Give data access to Einstein Analytics Capture from several domains
- Integrate Einstein Bot with Google Cloud
- Salesforce Einstein Bot close and minimize button getting enlarged
- How do I deploy an R code model in Salesforce Einstein Analytics Plus? Or find another alternative to Shiny?
- How to connect to Salesforce Einstein using Azure Data Factory?
- How to show variable's value in Dialog Name (Einstein Bot)
- Integrate Salesforce Einstein chatbot in website built using Dot Net and Angular
- How to change the Field Label and format for the formuale field created in the step in dashboard in einstein analytic?
- Custom date in Einstein Analytics
- Salesforce Chatbot : use NLP when the bot ask Question
- Is there any way to change Einstein Bot icon?
- How to integrate Amazon Alexa with Salesforce Einstein Bot
- How to pass url parameter into an Analytic Dashboard in Salesforce Lightning Page
- How to analyse multiple texts in a single request using CommunitySentiment Model of Salesforce Einstein?
- Is there any way to connect Einstein analytics to some 3rd party BI applications such as powerbi?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
No, for SalesForce objects or reports you can't use direct query. The full list of data sources you can or can't use direct query against, see the page at the MS Docs website:
https://learn.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources