Category "powerquery"

Is there a way to direct query Salesforce Objects to Power Query/Power BI without having to extract the object

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

Can I get data from power query to a vba variable?

I have a power query function, e.g. getData with one parameter filename Can I invoke that function directly in a vba variable? Something like: Sub MyTest() D

Find certain code combinations using text (sub)string in Power Query

I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Qu