cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Geberle Frequent Visitor
Frequent Visitor

Auto refresh for DAX tables

I have created a date table with a DAX expression similar to the following:

 

Kalender =
--
-- Start der Konfiguration

VAR StartJahr = 2008 -- Hier startet der Kalender
VAR EndeJahr = 2025 -- Hier endet der Kalender
VAR KalenderPrefix = ""

--- Ende der Konfiguration
--

VAR KalenderErsterTag =
    DATE ( StartJahr; 1; 1 )
VAR KalenderLetzerTag =
    DATE ( EndeJahr; 12; 31 )

VAR KalenderRoh =
    CALENDAR ( KalenderErsterTag; KalenderLetzerTag )

VAR KalenderBasis =
    GENERATE (
        KalenderRoh;
        VAR KalDatum = [Date]
        VAR KalJahr =
            YEAR ( [Date] )
        RETURN
            ROW (
                "Kalender JahrZahl"; KalJahr;
                "Kalender Jahr"; KalenderPrefix & KalJahr
            
            )
    )
RETURN
    SELECTCOLUMNS (
        KalenderBasis;
        "Datum"; [Date];
        "JahrZahl"; [Kalender JahrZahl];
        "Jahr"; [Kalender Jahr]
    )

The code works fine. But when I save the model as a PowerBI-Template (.pbit) and I try to reuse it in a new model, the will not generate automatically. Even if I safe the file as a .pbix file and reopen it. I allways have to manually refresh the table.

 

Is there a setting I can check?

 

Thanks for helping,

Georg.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Auto refresh for DAX tables

@Geberle,

 

The latest version of Power BI Desktop seems to work for .pbix file. As for the template, you may give feedback via https://ideas.powerbi.com/forums/265200-power-bi.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Geberle Frequent Visitor
Frequent Visitor

Re: Auto refresh for DAX tables

Hi Sam

 

Is there a difference between the store client and the client from the PowerBI website? I'm using the windows store client.

 

Greetings,

Georg