PowerBI 中的交互式对话框

有没有办法在 PowerBI 中创建交互式对话框?

我在查询编辑器中嵌入了 R 脚本，并且我希望有一个可以使用的交互方面:

 file<-winDialogString("文件输入?","")

此输入将用作读取 csv 的文件位置，每次有人打开并执行 PowerBI 文件的主副本时，他们都可以输入新的文件位置.

我也对 html、javascript、python... 任何可以提供帮助的东西持开放态度.

解决方案

实现您在 Power BI 中提到的最佳方法是利用

让Source = Csv.Document(File.Contents("\MacHomeDownloadsSalesJan2009.csv"),[Delimiter=",", Columns=12, Encoding=1252, QuoteStyle=QuoteStyle.None]),#"PromoteHeaders" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Transaction_date", type datetime}, {"Product", type text}, {"Price", Int64.Type}, {"Payment_Type",键入文本}，{名称"，键入文本}，{城市"，键入文本}，{州"，键入文本}，{国家"，键入文本}，{帐户创建"，键入日期时间}，{"Last_Login", type datetime}, {"Latitude", type number}, {"Longitude", type number}})在#改变类型"

如果我们希望用户输入文件位置(即\MacHomeDownloads)，我们可以在Power BI中设置一个参数:

然后我们可以更新查询使用参数:(Query -> Advanced Editor)

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

如果用户以后想更改参数(文件位置)，他们可以编辑参数并应用更改以刷新数据.

附:您甚至可以进一步 将 Power BI 文件导出为模板以允许用户将其实例化为新的 Power BI Desktop 报表(PBIX 文件).

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:

    file<-winDialogString("File input?","")

This input would be used as the file location for a read csv and everytime someone opens and executes the Master copy of the PowerBI file, they can input a new file location.

I am also open to html, javascript, python... anything that could help.

解决方案

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:

let
    Source = Csv.Document(File.Contents("\MacHomeDownloadsSalesJan2009.csv"),[Delimiter=",", Columns=12, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Transaction_date", type datetime}, {"Product", type text}, {"Price", Int64.Type}, {"Payment_Type", type text}, {"Name", type text}, {"City", type text}, {"State", type text}, {"Country", type text}, {"Account_Created", type datetime}, {"Last_Login", type datetime}, {"Latitude", type number}, {"Longitude", type number}})
in
    #"Changed Type"

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

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

let
    Source = 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).