Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a Power BI Desktop report with a connection to a Salesforce Object that I then publish to an online workspace. In the Query Editor, I am filtering out both columns and rows from the Object.
I have 3 questions:
1. In the trace files (I see 2 Mashup files that get generated), one includes a SQL query that appears to have incorporated the edits I made in the Query Editor. What is the other Mashup file doing? It references the Salesforce URL and appears to be loading something like metadata.
2. In the Query Editor, the entire Object is accessible. How is this the case if the entire Object isn't getting loaded into the workbook?
3. When it comes to publication, is the entire object loaded into the Power BI workbook and ultimately published as the Dataset in the workspace? Or is only the filtered Object published as the Dataset in the workspace?
Hi @emmet,
1. It seems that you want to have an analysis of the trace files. You could have a guide of this blog which introduce us what the trace file do and you also could analyze the files with this tool so that it will be more easier.
2. I'm not clear about your question "How is this the case if the entire Object isn't getting loaded into the workbook"? Do you mean that if you cannot load all tables from SalesForce Object in Query editor? We need to analyze it according to the specific situation.
3. When it comes to publication, only the filtered Object in query editor will be published as the Dataset in the workspace.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |