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:

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:

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.

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).