Power BI self BI report

[Elieekh17]

Dear Community,

Is anybody knows if we have the possibility to create a report with drag and drops or free usage of report allowing users to create their own report in power bi ? other than fields parameters and build access dataset solutions?

Thank you

[audreygerred]

Hi! The only way to allow users to drag and drop to create their own report using your semantic model is build access - this requires the pro license. If you want it to be a free option you can use field parameters or use the option to allow the users to personalize visualizations: Let users personalize visuals in a report - Power BI | Microsoft Learn

[SamWiseOwl · Accepted solution]

Hi @Elieekh17 

Have you checked out the personalize options?

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals?tabs=powerbi-...

There is also the Q&A visual where they can ask questions that generate visuals:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-q-and-a?tabs=powerbi-deskt...

[Elieekh17]

THank you SamWiseOwl , I thought about this but the need is to allow users to use fields and measures by drag and drop freely in power bi to create their own report

[SamWiseOwl]

Have you tried the SandDance visual?

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000430

You can add loads of fields to it and then the user can tick different visuals and fields.

Here is an embedded version for you to try out:
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Commodity-Correlation-quot-Double-Hel...

[Elieekh17]

alright will check the personalized report option . thank you

[SamWiseOwl]

Have you looked at SandDance:
https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Commodity-Correlation-quot-Double-Hel...

Its fun!