Примери за използване на The power query на Английски и техните преводи на Български
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
The Power Query Add- In.
Excel 2010-2013: Click the Power Query tab, then From Web.
In the Power Query ribbon tab, click Options.
Create advanced queries using the Power Query formula language.
In the Power Query ribbon tab, click From Table.
You can open Query Editor from the Power Query ribbon in Excel.
In the Power Query ribbon tab, click From Other Sources> From Facebook.
Any such data query is expressed using the Power Query Formula Language.
You will use the Power Query feature in Excel to do this.
In the Power Query ribbon tab, select From Other Source> From OData Feed.
Take a look at the following resources to get involved with others in the Power Query community.
In the Power Query ribbon tab, click From Online Services> From Dynamics 365.
Take a look at the following resources to get involved with others in the Power Query community.
In the Power Query ribbon, in Settings, select Data Source Settings.
You can see the M code in its entirety by clicking on the Advanced Editor option in the Power Query ribbon.
In the Power Query ribbon tab, select From Database> From PostgreSQL Database.
When you're done, press OK to confirm your actions, and Power Query will complete the transformation,returning to the Power Query Editor.
In the Power Query ribbon tab, select From Other Sources> From SharePoint List.
For detailed information about connecting to various data sources using Power Query, see Import data from external data sources in the Power Query for Excel Help.
In the Power Query ribbon tab, click From Other Sources> From Active Directory.
To view the Query Editor without loading orediting an existing workbook query, from the Get External Data section in the Power Query ribbon tab, select From Other Sources> Blank Query. .
Click the Power Query tab in the Ribbon, then select Get External Data> From Text.
Download the version of the Power Query add-in that matches the architecture(x86 or x64) of your Office installation.
The Power Query preview displays the results of each query step in the Editor.
For more information about the Power Query formula language, see Learn about Power Query formulas, and Power Query M Reference….
The Power Query editor gives you a great deal of flexibility with how you get and transform your data.
If you don't see the Power Query tab, make sure you have downloaded and installed the Power Query add-in.
The Power Query command bar is the green area at the bottom of the Editor dialog.
You can use the Power Query Formula Language to combine multiple formulas into query steps that have a data set result.