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 copied it into the folder 'xl/model' of the Excel group of folders. This is the procedure I found on this blog in order to achieve the result and I followed it, but in the moment in which I open the Data Model in Excel I always got an alert that says:'Impossible for PowerPivot to upload the data model'.

 

Said that, I have the latest version of Power BI (2.119.666.0 at 64-bit of July 2023) and Microsoft 365 (Excel Version 2305 Build 16.0.16501.20074 at 64-bit).

 

Has anyone faced this problem before?

Thanks,
Nate

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