Power Query – October 2014 update

power bi for office 365

The Power Query tool has just been updated and there are some pretty neat features rolled out:

  1. New Transfomation: Use Headers as First Row.
  2. Column Name field in Merge Columns dialog.
  3. Quick Access Toolbar in Query Editor dialog.
  4. Warning for stale data previews in new queries.
  5. Function Invocation from Search.
  6. Preserve Excel Number formats in the worksheet on query refresh.

Microsoft has posted a video containing a brief overview of the update:

Along side this update – there is also an updated Salesforce connector for Power Query which you need to install after installing the above update.

There is a MSDN blog with more info here: MSDN

Downloads:

Power Query update

Salesforce connector

Få besked om næste indlæg

Skriv dig gerne op til at modtage en mail, ved næste indlæg. Det kan du gøre nedenfor.



Marketing stuff

Our emails contain marketing stuff, so we need to give you some fine quality fine print: brianbonk will use the information you provide on this form to email you with updates and marketing. You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at help@brianbonk.dk. We use Mailchimp as our marketing platform. By checking the box to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing, and that we may process your information in accordance with these terms.

Følg mig på Instagram

Leave a Reply

Your email address will not be published. Required fields are marked *

en_USEnglish