Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Essbase (beta) measures all null

I'm using a connection string formatted like so: http://[NAME]:[PORT]/aps/XMLA and can successfully connect to our Essbase server. 

I can view cubes within the server as well as each cube's dimensions and measures. 

Dimension members return successfully; I can display them in visuals on the canvas. 

However, all measures always show as null. This is true in the Get Data dialogue, in the query editor, wherever. 

Does anyone have any idea why this is occurring? Or has anyone successfully used essbase cubes in the Report Server version of PBI Desktop? If so, I'd like to see all the details of the connection.

The Essbase admin says we're on version 11.1.2.4.

2 REPLIES 2
Anonymous
Not applicable

Hi I am not an IT person but played a lot with the Essbase connector. Had the Null issue on my side. The solution was to check via smartview what is the minimum set of filters returning a value from Essbase and then trying to replicate it via connector. It was loads of trial and error but worked in the end. 

Anonymous
Not applicable

I'm sorry, can you elaborate? I'm not familiar with Essbase at all. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors