Forum Discussion
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...
Afraid that hack doesn't work on modern Excel and Power BI Desktop, lot of changes were made in both for recent 5 years.
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
NateP86
So, that's cross filtering in both direction on model likefilter 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.
