Self Service report in power BI services

[Anonymous]

I was asked to create a self service view or report where it can have column selector i.e client can pre-select columns they want and download it as csv or Excel with the records/data dump as well as if statistics or chart can be use to analyze that pre-selected columns as their dashboard.

Is this possible in Power BI services? Someone claims that it can be done with paginated reports and Analyze Excel. Is it true?

Any ideas please

[dj8830]

Have you solved this

[vanessafvg]

it depends on how much data they want to export?  you can create a self-serve solution in power bi using the personalise visuals feature with perspectives

https://www.youtube.com/watch?v=b0kvxj_d6QQ

also make sure you understand the limitation that comes  with exporting out of power bi and is this the right solution?  

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

[Anonymous]

I have watch the video but that is not what i was looking for.

What my requirement is that - my client will see all fields in a column selector and they can drag any fields that want in the canvas where later they can download with the data and visual as well.

It is just like when on is building report in ssrs using wizard, you drag fields to row or column then it will produce a table or matrix. That process feel of drag and drop is what the user want.  

[vanessafvg]

The personalise visuals does offer a drag and drop experience but its not straight forward as you mention it.   

You can also just give a user access to a dataset in a workspace and they can use the dataset to create their own reports, use the dataset to drag and drop fields onto the canvas from the dataset and then export the data  from the visual. 

They can export the visual as a pdf or power point, but you cannot export the visual out any other way, and there are limits as I said as to how much data you can export out.  

Maybe it makes more sense to do it in excel?

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel