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.
I have recently connected to Salesforce Object, however my opportunity or account object consist alot of fields. Is there a way to quickly filter out the object fields without writing any advance editior syntax ?
The current way that I am doing is by manually removing the object one by one and it is very time consuming.
Solved! Go to Solution.
@Anonymous,
In Query Editor of Power BI Desktop, you can use "Choose Column" option to select the columns that you want to reserve.
Regards,
Lydia
The easiest way is to use the choose columns interface/remove other columns as this allows you to search for the columns you want easier than removing one by one.
Also if you include this at the start of your query, some query folding does happen in some cases but I havent worked out enough to say for sure what causes it.
Hi @Anonymous,
Can you share a screenshot on how you select and search the object field ?
@Anonymous,
In Query Editor of Power BI Desktop, you can use "Choose Column" option to select the columns that you want to reserve.
Regards,
Lydia
would the hidden columns still be part of the refresh or will it save 'space' and not have them synchronize into the pbix file?
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.