Skip to content Skip to sidebar Skip to footer

Interactive Dialog Box In Powerbi

Is there a way to create an interactive Dialog box in PowerBI? I have R script embedded into the query editor, and I would like to have an interactive aspect to where I can use:

Solution 1:

The best way to achieve what you mentioned in Power BI is to make use of parameters and parameterize your queries to get the csv file.

Say we have a csv file named SalesJan2009.csv. When you import it to Power BI you should have something like:

text/csv

data

letSource = Csv.Document(File.Contents("\\Mac\Home\Downloads\SalesJan2009.csv"),[Delimiter=",", Columns=12, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Transaction_date", typedatetime}, {"Product", typetext}, {"Price", Int64.Type}, {"Payment_Type", typetext}, {"Name", typetext}, {"City", typetext}, {"State", typetext}, {"Country", typetext}, {"Account_Created", typedatetime}, {"Last_Login", typedatetime}, {"Latitude", typenumber}, {"Longitude", typenumber}})
in
    #"Changed Type"

If we want users to input the file location (i.e. \\Mac\Home\Downloads\), we can set up a parameter in Power BI:

new parameter

file location

Then we can update the query to use the parameter: (Query -> Advanced Editor)

letSource = Csv.Document(File.Contents(#"FileLocation" & "SalesJan2009.csv"), ...
    ...

If users want to change the parameter (file location) later on, they can edit the parameter and apply changes to refresh the data.

edit parameters

enter parameters

apply changes

P.S. You can even further export the Power BI file as a template to allow users to instantiate it as a new Power BI Desktop report (PBIX file).

Post a Comment for "Interactive Dialog Box In Powerbi"