Control of what we see in each page of the Power BI

[Anonymous]

Hi Experts,

I have different measures and requirements and as part of requirements I need to present entire raw data so the user can add his own metrics in the last page and If that is feasible i don't want to clutter other pages with information other than measures. 

Is this possible ?

Thanks a ton

[Anonymous]

@Whitewater100  Thansk a lot. this is a good information, but there is no plan to give them any access other than able to select filters and I must provide a way so they can down load all the datasets (thousands of columns). I just have to keep adding to the table for them to download. with same dashboards and many many options in filters but that should be limited to last page. 

An example here, the fields you see in the picture will further decrease but in the last page "All Details" All the data should be displayed. 

Is that feasible?

[AlexisOlson · Accepted solution]

If you have thousands of columns that you want the user to be able to choose from to download data, then I'd recommend unpivoting the data so that your table has a fixed number of columns.

[Anonymous]

Thank you @AlexisOlson  I will explore this option. This was the whole intent of me asking. Thanks a ton

[daXtreme]

If you have a need to let users download massive amounts of data (with thousands of columns), then PowerBI is not the right tool for the job. You should look for a different solution. One of them would be PowerBI Paginated Reports (the successor to SSRS).

[daXtreme]

"... the user can add his own metrics in the last page". I very much think that only the author of a report can add metrics/measures to a dataset. A user can only use what's already been built by the author. Unless... you want to turn your users into report authors, which will wreak havoc on the system.

[Anonymous]

@daXtreme  Apologies, you caught me wrong there. I meant, add the existing metrics His own there, I meant his/her own metrics which are provided. If not, they want to down load and use Excel Pivot. Sorry 

[Anonymous]

Sorry @daXtreme  let me clarify, the end user is wanting to download entire data of excel and do adhoc reports and author is giving only control to be able to see total information as a table, metrics and filters. End user is not able to edit but only select from the fields to the table. that too only in the last page. 

If that is possible, the other pages should not show any unwanted fields to keep it clean. 

The need of the stakeholder is to get all the data afresh for further processing and validation.

[Whitewater100]

Hi:

Yu can use the personalize visual options so your users can change the charts you have made and pull in or take out any measures you have developed. It's a feature you check off on and when the report is in distributed via app in SERVICE they can update and edit there with other measures.

As long as you allow editing of the report your users can update at will.

They can also just connect to your DATASET and have your tables at their disposal. When they go to Get Data choose Power BI Datasets and create their own eport from scratch.

If I haven't answered like you expected can you provide some data or images that help understanding?

Thanks