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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
powerBI_L1
Regular Visitor

Browsing Cube in PowerBI

I am trying to see if there is a way in PowerBI(using builtin or custom visuals) where the end user can drag and drop the dimensions or mesaures into the report.


The basic idea is to create blank report and the end user will choose what dimensions\measures they want to analyse. My requirement is similar to how we can browse the cube in SSMS.

 

I want to be able to do that same in PowerBI. Is this possible?

 

So far, based on what I tested and researched, it looked like we cannot slice and dice the data once deployed. Any ideas?

3 ACCEPTED SOLUTIONS

are you wanting to expand individual rows?  

 

If you want to expand all the data you can use the new matrix visual, you can also drill down into the data but sadly I dont think you can expand an individual row in the table/matrix because i have been looking for a solution like this too and haven't found one yet.

 

seems to be a common requirement so i hope the power bi team sort it out soon.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

You could use the new matrix visualization for drill down. You could also just add a date slicer perhaps?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

v-qiuyu-msft
Community Support
Community Support

Hi @powerBI_L1,

 

You can create a report connect live to SSAS in desktop, which you can get all dimensions and measures like in SSMS. Then there are two methods you can try:

 

1.  Publish that report to a Power BI app workspace. Grant member Edit permission in this app workspace. Each member can edit the report. See: Create and distribute an app in Power BI

2. Publish that report to My Workspace, then create a content pack to package report and dataset, publish the content pack to whole organization or specific group. End user can get this content pack and make a copy of content pack to customize it. See: Intro to organizational content packs in Power BI.

 

To get expand and collapse feature, you can vote on this idea: Matrix +/- Collapse/ Expand Buttons. You can slicer data in matrix preview on different levels as suggested by other guys: Use the new Matrix visual in Power BI Desktop (Preview).

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
v-qiuyu-msft
Community Support
Community Support

Hi @powerBI_L1,

 

You can create a report connect live to SSAS in desktop, which you can get all dimensions and measures like in SSMS. Then there are two methods you can try:

 

1.  Publish that report to a Power BI app workspace. Grant member Edit permission in this app workspace. Each member can edit the report. See: Create and distribute an app in Power BI

2. Publish that report to My Workspace, then create a content pack to package report and dataset, publish the content pack to whole organization or specific group. End user can get this content pack and make a copy of content pack to customize it. See: Intro to organizational content packs in Power BI.

 

To get expand and collapse feature, you can vote on this idea: Matrix +/- Collapse/ Expand Buttons. You can slicer data in matrix preview on different levels as suggested by other guys: Use the new Matrix visual in Power BI Desktop (Preview).

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks every one. I am trying to doing this on premises PowerBI

 

Also, After I enabled the new matrix preview fliter, I am not able to deploy the report. Is this because this is a preview feature?

@powerBI_L1 what error are you getting?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Greg_Deckler
Super User
Super User

You should be able to create a Direct Query query to the cube. What type cube is it Tabular or MDX? What you are discussing is exactly what Power BI was designed for so I must be missing something.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks smoupre for the help. I am using MDX and "Connect Live" connection. I guess thats direct query,so i do not see any explicit connection "DirectQuery" in PowerBI Desktop.

 

The issue is giving the end user the ability to slice and dice the data. Let me explain with an example. Say, you have TotalSales as Measure and Date as Dimension and Date is a hireachy( Year- Quarter- Month). 

 

So, Rigth now, I am using Table Visualization( I do not want any bars\graphs for this), and it giving stragith Table display. There is no way for me to collapse\expand(slice\dice) the data by based on the Date dimension.

 

I want the end user to have the ability to slice and dice the date dimension as needed.

 

You could use the new matrix visualization for drill down. You could also just add a date slicer perhaps?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

are you wanting to expand individual rows?  

 

If you want to expand all the data you can use the new matrix visual, you can also drill down into the data but sadly I dont think you can expand an individual row in the table/matrix because i have been looking for a solution like this too and haven't found one yet.

 

seems to be a common requirement so i hope the power bi team sort it out soon.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Sounds like you're talking about drilldown. You'll want to use the new matrix preview visual for that. You have to turn it on in your options under the preview settings.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.