Forum Discussion

Txtcher's avatar
Txtcher
Copper Contributor
May 09, 2024

Create table (not a pivot table) from Data Model

I have set up the data in my data model.  Used Power Query Editor for ETL.  I set up the relationships in the model with a fact table and my 3 dimension tables.  Now I want to create a data table in ...
  • SergeiBaklan's avatar
    SergeiBaklan
    May 09, 2024

    Txtcher 

    Most probably you can do that. You may check

    Using join functions in DAX - SQLBI

    From SQL to DAX: Joining Tables - SQLBI

    for the details, plus lot of other materials.

     

    As for the Power BI not sure what do you mean. In general that's the same data model (aka dataset, semantic model) to work with which DAX queries are used; and same Power Query to prepare external data sources (dataflows) or internal one. If you have Power BI Pro or higher licenses you may do all preparations in Power BI Services creating dataflows and/or semantic model data from which will be loaded to Excel. Refresh is scheduled one or initiated by Power Automate. Or manual.

Resources