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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
bludra
Frequent Visitor

Display all columns of dim, fact table in olab cube on power bi

Hi everyone,

I have a problem when show all fields in dim and fact table on power bi by olab cube builded in sql server database

F1. I have created an olab cube in sqlserver

bludra_0-1681210571746.png

F2. But when I import that olab cube on power bi, it just shows only id key of those above table as that picture below:

bludra_1-1681210666979.png

 

So, how can I appear more fields of dim, fact table to draw chart as I want on power bi ? Thank you in advance.

 

OLAP Cube ;

1 ACCEPTED SOLUTION
bludra
Frequent Visitor

I found the way to solve that. Thank you everyone for concern my deal.  I would like to close topic.

View solution in original post

3 REPLIES 3
bludra
Frequent Visitor

I found the way to solve that. Thank you everyone for concern my deal.  I would like to close topic.

d_gosbell
Super User
Super User

I cannot reproduce this issue. When I import from a multi-dimensional cube I can select whatever attributes I like.

 

Note that it's not a best practice to import from a multi-dimensional model. It's usually better to pull the data from the same source as the multi-dimensional model or to do a live connection.

@d_gosbell : I try to connect with option connect live. But it does not change right now.

bludra_0-1681280261188.png

Then 

bludra_1-1681282717737.png

After I still has show just only keys:

bludra_2-1681282796477.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.