topic Re: Display all columns of dim, fact table in olab cube on power bi in Report Server

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

bludra — Tue, 11 Apr 2023 11:00:32 GMT

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

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:

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

;

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

d_gosbell — Wed, 12 Apr 2023 01:33:22 GMT

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.

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

bludra — Wed, 12 Apr 2023 07:00:09 GMT

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

Then

After I still has show just only keys:

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

bludra — Fri, 14 Apr 2023 02:15:23 GMT

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