Brunner

BI

  • Home

  • Services

  • Live Demos

  • Über uns

  • Team

  • Kunden

  • Kontakt

  • Blog

  • More...

    Use tab to navigate through the menu items.
    • Alle Beiträge
    • Power Query
    • Optimization
    • Power BI Service
    • Data refresh
    • Dataflows
    • Frontend
    • DAX
    • Offtopic
    Suche
    New ways to check if queries fold in Power Query
    Brunner_BI
    • 29. Jan.
    • 1 Min.

    New ways to check if queries fold in Power Query

    This article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not
    12 Ansichten0 Kommentare
    Allocating amounts using lists in Power Query
    Brunner_BI
    • 30. Dez. 2021
    • 2 Min.

    Allocating amounts using lists in Power Query

    We will show you how to create dates between a start and an end date using the list operator in Power Query. This can be handy as well for a
    7 Ansichten1 Kommentar
    Dataflows gets around the 3,000 cell enter data limit in Power BI
    Brunner_BI
    • 14. Dez. 2021
    • 1 Min.

    Dataflows gets around the 3,000 cell enter data limit in Power BI

    This blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop
    18 Ansichten0 Kommentare
    How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI
    Brunner_BI
    • 29. Dez. 2020
    • 1 Min.

    How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI

    When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...
    1.336 Ansichten8 Kommentare
    Changing data types that do not break query-folding in Power Query / Power BI
    Brunner_BI
    • 17. Dez. 2020
    • 1 Min.

    Changing data types that do not break query-folding in Power Query / Power BI

    There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source
    1.008 Ansichten0 Kommentare
    Creating a custom fiscal calendar in Power BI
    Brunner_BI
    • 15. Dez. 2020
    • 1 Min.

    Creating a custom fiscal calendar in Power BI

    Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.
    258 Ansichten0 Kommentare

    Brunner

    BI

    LINKS
    • Home
    • Services
    • Live Demos
    • Über uns
    • Team
    • Kunden
    • Kontakt
    • Blog
    KONTAKT

    gregor@brunner.bi

    Tel: +41 76 723 2735

    ​

    Brunner BI GmbH
    Route du Jura 49
    1700 Fribourg
    Switzerland

    ​

    CHE-242.781.338

    ​

    Privacy Policy

    SOCIAL
    • LinkedIn
    • Facebook

    © 2021 by BRUNNER BI