PowerBI中的交互式对话框 [英] Interactive Dialog Box in PowerBI

问题描述

是否可以在PowerBI中创建一个交互式对话框？

我在查询编辑器中嵌入了R脚本，并且希望在使用方面具有交互性：

  file< -winDialogString（文件输入？，）
  

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

我也欢迎使用html，javascript，python ...可能有帮助的任何东西。

解决方案

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

  let 
源= Csv.Document（文件。内容（ \\Mac\Home\Downloads\SalesJan2009.csv），[Delimiter =，，Columns = 12，Encoding = 1252，QuoteStyle = QuoteStyle.None]），
＃ 升级标题 = Table.PromoteHeaders（源，[PromoteAllScalars = true]），
＃更改类型 = Table.TransformColumnTypes（＃升级标题，{{ Transaction_date，类型datetime}，{产品，键入文本}，{价格，Int64.Type}，{ Payment_Type，键入文本}，{名称，键入文本}，{城市，键入文本}，{州，键入文字}，{国家/地区，键入文字}，{ Account_Created，键入datetime}，{ Last_Login，键入datetime}，{纬度，键入数字}，{经度，键入数字}}）
 in 
＃更改类型 
  

如果我们希望用户输入文件位置（即 \\Mac\Home\Downloads\ ），我们可以在Power BI中设置参数：

然后我们可以更新查询以使用以下参数：（查询->高级编辑器）

  let 
源= Csv.Document（File.Contents（＃ FileLocation& SalesJan2009.csv），... 
 ... 
  

如果用户以后要更改参数（文件位置），则可以编辑参数并应用更改以刷新数据。

PS您甚至可以进一步将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("\\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", 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. \\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)

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

这篇关于PowerBI中的交互式对话框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！