User Profile
hmasim_
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Re: Cubevalue issues connecting to Power BI Dataset
can you try to go to connection properties and under OLAP drill through, increase the number of records to retrive? I have sucessfully connected to powerbi data set and bulding custom reports in excel. This combo seems working well, but i am not sure if this is really a robust solution? lately my intellisense in cube formulas stoped working. Any reason for it?3.6KViews0likes0CommentsAnalyze in Excel with CUBE functions
Hi There, I have two questions. 1) To create flexible and specific format report our organisation is considering to connect with Powerbi sementic model and produce custom reports in excel using CUBE functions. - the question is, is it a robust solution? what are pros and cons of it? 2) How I disconnect from CUBE functions to paste all data as values, specially when i want to share file with collegues or external parties? I tried to disconnect / Delete connection string used in CUBE formulas which resulted in #NA error. I also tried to change file location or copy file from one workbook to new with no success. I read about offile OLAP option whihc is greyed out and it seems that it is not supported. appriciate solution and expert opinion. Many thanks.Solved2.5KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.