Forum Discussion

Dan2's avatar
Dan2
Helper I
8 years ago
Solved

Parameters not being published when using the powerbi rest import method

Part of our deployment process is upload pbix files to the apropriate workspace based on environment, etc. And this deployment process uses the powerbi rest api's import method to do this. We use par...
Need Help
  • Dan2's avatar
    Dan2
    8 years ago

    I had a discussion with Microsoft and found that if the parameters are not being used in the advanced query editor then when using the powerbi rest api import method the parameters will not be migrated. So you must be using these parameters in some way otherwise the parameters will not make it into the dataset.

Dan2's avatar
Dan2
Helper I
8 years ago

I had a discussion with Microsoft and found that if the parameters are not being used in the advanced query editor then when using the powerbi rest api import method the parameters will not be migrated. So you must be using these parameters in some way otherwise the parameters will not make it into the dataset.

jaryszek's avatar
jaryszek
Super User
1 year ago

Hello Dan2

I have the same issue like you.
What do you mean by some way? 

I have query where I am using parameter like here:

let
    Source = AzureStorage.Blobs("vncmcostexports"),
    powerbidatasources1 = Source{[Name="powerbidatasources"]}[Data],
    #"Filtered Rows" = Table.SelectRows(powerbidatasources1, each ([Name] = "AvailabilitySets.csv")),
    #"Filtered Hidden Files1" = Table.SelectRows(#"Filtered Rows", each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
    #"Removed Other Columns" = Table.SelectColumns(#"Invoke Custom Function1",{"Name", "Content"}),
    #"Invoke Custom Function2" = Table.AddColumn(#"Removed Other Columns", "Transform File", each #"Transform File"([Content])),
    #"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function2", {"Transform File"}),
    Headears =  #"Removed Other Columns1"{0}[Transform File],
    Result = if NoData = true then #table(Table.ColumnNames(Headears), {}) else Headears
in
    Result

 and parameter is: 


why this is not working? 
After importing using REST APIs they are disappearing...

Best,
Jacek