Home

Cube Function Data model issue

%3CLINGO-SUB%20id%3D%22lingo-sub-540473%22%20slang%3D%22en-US%22%3ECube%20Function%20Data%20model%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540473%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20Data%20model%20power%20pivot%20Excel%20through%20the%20PowerQuery.%3C%2FP%3E%3CP%3EI%20have%20make%20some%20pivot%20tables%20also%20up%20till%20pivot%20tables%20its%20working%20fine%20but%20I%20don't%20know%20why%20when%20I%20add%20some%20CubeValue%20functions%20and%20press%20save%20button%20the%20Data%20Model%20got%20deleted.%20I%20thought%20there%20is%20some%20issue%20with%20workbook%20so%20I%20created%20new%20file%20from%20scratch%20level%20but%20face%20same%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%202016.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542205%22%20slang%3D%22en-US%22%3ERe%3A%20Cube%20Function%20Data%20model%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F336609%22%20target%3D%22_blank%22%3E%40abatahir%3C%2FA%3E%26nbsp%3B%D0%B1%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20tried%20to%20reproduce%20on%20very%20simple%20model%2C%20have%20no%20problems.%20Formula%20like%3C%2FP%3E%0A%3CPRE%3E%3DCUBEVALUE(%22ThisWorkbookDataModel%22%2C%22%5BMeasures%5D.%5BSum%20of%20Value%5D%22)%3C%2FPRE%3E%0A%3CP%3Edata%20to%20data%20model%20added%20by%20PQ.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-549234%22%20slang%3D%22en-US%22%3ERe%3A%20Cube%20Function%20Data%20model%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F336609%22%20target%3D%22_blank%22%3E%40abatahir%3C%2FA%3E%26nbsp%3BHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_self%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
abatahir
Occasional Visitor

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

@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.

 

@abatahir Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies