Skip to content
Trainings, consultancy, tutorialsTrainings, consultancy, tutorials
Trainings, consultancy, tutorials
Understand it right now!
  • Home
  • For corporations
  • Individually
  • Consultancy
  • References
  • Pricing
  • Tutorials
  • Contact
  • Where
  • EN
    • CZ
    • SK
    • EN

  • Registrace
  • Přihlášení
 0
  • No products in the cart.

Subtotal: 0 Kč

View Cart Checkout

 
  • Home
  • For corporations
  • Individually
  • Consultancy
  • References
  • Pricing
  • Tutorials
  • Contact
  • Where
  • EN
    • CZ
    • SK
    • EN

Tutorials

You are here:
  1. Home
  2. Tutorials
  3. Power BI
  4. Powerbi.com and Power BI Desktop
  5. Power Query in Power BI

Power Query in Power BI

All related tutorials

  • Addressing rows, columns and values in Power BI
  • Connect Power BI to a webpage
  • Connect Power BI with Google Analytics
  • Connect Power Query to a whole SharePoint folder
  • Data quality and distribution check in queries
  • Fuzzy matching in Power BI queries
  • Group by to merge texts – something like CONCATENATEX, but in queries
  • How to schedule updates in Power BI
  • How to simply connect Power BI to Excel file stored on SharePoint
  • How to user Power BI to monitor users activities in Office 365.
  • Incremental refresh in Power BI very briefly
  • Merging of data from all files in folder in Power BI
  • Merging of queries based on date or number intervals – Table.SelectRows function
  • Multiple columns as a key for merging in Power Query
  • Parameters in Power BI queries
  • PDF as a source for Power BI
  • Pivot Column in Power Query
  • Power BI – writing of data directly in Power BI Desktop
  • Power BI connected to Dynamics 365
  • Power Query – how to simply get hyperlinks from webpages
  • Power Query and assigning to ranges (merging of tables like VLOOKUP with last argument 1/TRUE))
  • Python in Power BI – how does it work
  • Remove the typing errors automatically (Query editor in Power BI)
  • Value from previous row – Power Query, M language

Leave a Reply Cancel reply

Your email address will not be published.

CAPTCHA
Refresh

*

clear formPost comment

Did you know we have a LinkedIn page?
For companies
Interested in company training?
Excel trainings from beginners to experts. And other Microsoft Office applications as well.
MORE INFORMATION
Individually
  • Consultancy for complex spreadsheets creation
  • Preparation for your new job
  • Preparation for job interview
MORE INFORMATION
Spreadsheet development
VBA - Power BI
  • Development of corporate databases
  • Reports, visualizations, plans, pricelists, budgets...
  • Merging of databases, cleaning, exports
MORE INFORMATION
Recent Comments
  • Dan Paul on SUMMARIZE – groupping in data models (DAX – Power Pivot, Power BI)
  • Haider on LOOKUPVALUE – assigning of values from other table without relation (DAX – Power Pivot, Power BI)
  • namereunused on Remove filter in visuals
  • Anonymous on SUMX vs SUM – key differences very briefly (DAX – Power Pivot, Power BI)
  • jo on SELECTCOLUMNS – select some columns from table (DAX – Power Pivot, Power BI)

ExcelTown - Contact

+420 602 274 999
info@Exceltown.com

Hot news

  • Lists in Power Query
  • How not to spoil your Power BI data model – 7 critical rules
  • Field parameters and how to use them in Power BI

© exceltown.com / 2020 Vyrobilo studio bARTvisions s.r.o.