Forum Discussion

abatahir's avatar
abatahir
Copper Contributor
May 07, 2019

Cube Function Data model issue

I have created a Data model power pivot Excel through the PowerQuery.

I have make some pivot tables also up till pivot tables its working fine but I don't know why when I add some CubeValue functions and press save button the Data Model got deleted. I thought there is some issue with workbook so I created new file from scratch level but face same issue. 

I am using Excel 2016.  

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    abatahir б

     

    I tried to reproduce on very simple model, have no problems. Formula like

    =CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Value]")

    data to data model added by PQ.

     

Resources