Forum Discussion

NateP86's avatar
NateP86
Copper Contributor
Jul 24, 2023

Data model from Power BI to Excel

Hi everybody, I'd like to import a Data Model made in pbix  into an xlsx, so passing from Power BI to Excel.   I unzipped both, copied the DataModel file from the pbix, renamed it as item.data and...
BI & Data Analysis
Excel
office 365
power bi
SergeiBaklan's avatar
SergeiBaklan
MVP
Jul 24, 2023

NateP86 

Afraid that hack doesn't work on modern Excel and Power BI Desktop, lot of changes were made in both for recent 5 years. 

NateP86's avatar
NateP86
Copper Contributor
Jul 30, 2023

SergeiBaklan I understand. I raised this ticket because I need to implement in my project just a simple feature which would consist in the possibility to have a filter, in a power pivot, that consider some time intelligence labels such as YTD, MTD, WTD and so on.

 

In order to achive this I created in my Excel file two tables: Time Intelligence Selection (with all the labels per date) and the Calendar. The point is that there's a one to many relationship and not a many to one that I would need.

 

Do you think there's a way to achieve the result considering that importing a data model in Excel is no longer feasible?

 

Thanks,

Natan

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jul 30, 2023

    NateP86 
    So, that's cross filtering in both direction on model like

    filter could be like

    For such model you could do everything in Excel. Major part of the job could be done with CROSSFILTER(), e.g. for above sample like

    Measure, new = CALCULATE(
	[Measure, old],
	CROSSFILTER(Period[Datekey],Calendar[DateKey],Both)
)

    Assume you don't use implicit measures, but that's best practice in any case.

Resources