Skip to content
Trainings, consultancy, tutorialsTrainings, consultancy, tutorials
Trainings, consultancy, tutorials
Understand it right now!
  • For corporations
  • Individually
  • Consultancy
  • Tutorials
  • Contact
  • Where
    Můj účet
    • Registrace
    • Přihlášení
     0
    • No products in the cart.

    Subtotal: 0 Kč

    View Cart Checkout

     
    MENU
    • For corporations
    • Individually
    • Consultancy
    • Tutorials
    • Contact
    • Where
    You are here:
    1. Home
    2. Tutorials
    3. Power BI
    4. Powerbi.com and Power BI Desktop
    5. Power Query in Power BI

    Tutorials

    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)
    • Use Power Query to get data from email folder, calendar etc. (Exchange)
    • Value from previous row – Power Query, M language

    Did you know we have a LinkedIn page?

    A nedal by se Váš kurz zaplatit z dotací?

    Určitě ano. Cenu kurzu Vám mohou dotace zaplatit buď celou nebo z 82%.

    Úhrada se liší podle toho, jestli jste jednotlivec nebo firma.

    • Dotace pro firmy
    • Dotace pro jednotlivce
    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

    Našimi kurzy prošlo více než 10 000+ účastníků

    2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami

    Potřebujete se na něco zeptat?

    Jsme tu pro vás každý den

    +420 602 274 999

    info@exceltown.com

    Pište kdykoliv. Odpovíme do 24h

    ExcelTown na LinkedInu

    Sledujte nás

    Excelujte s
    ExcelTownem

    ExcelTown.cz
    • Contact
    Naše služby
      Návody
        Návody

          © exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.