Forum Discussion

6 Replies

  • v-micsh-msft's avatar
    v-micsh-msft
    Microsoft Employee
    9 years ago

    Hi googlogmob,

    If I understanding clearly, you would like to have invoke function available with data refresh, right?

    Currently this is not available. And there are already ideas submitted on this topic:

    Make functions refreshable when the data source is a parameter of the function

    Please check it and vote if necessary.

    By the way, take a look at the thread below:

    How to setting a dynamic URL connection

     

    Please reply back if I have any misunderstandings.

    Regards

      • googlogmob's avatar
        googlogmob
        Advocate II
        9 years ago

        I folowed this link and tried use binary converting

         

        Here is my code below

         

        Query "Link"

         

        let
    
    query = "Валюты",
    
    v1 ="http://" & КлиентIP & "/hs/getting/PowerBI/@nAl1t1kx5$/start?storedprocedure=" & query & "&queryparameters=СтруктураПараметраЗапроса = 'НачалоАнализа = '",
    v2 = "'; ОкончаниеАнализа = '",
    v3 = "000000';"""";",
    l = v1 & ПериодС & v2 & ПериодПо & v3,

    b2 = Text.ToBinary(l, 1251),
    textFormat = BinaryFormat.Text(225, 1251) 
in
    textFormat(b2)

         

        Query "Main":

         

        let
   
    Запрос =  Json.Document(Web.Contents( link4 )),
    #"Преобразование" = Table.ExpandListColumn( Record.ToTable(#"Запрос") , "Value"),

    #"Разверачивание" = Table.ExpandRecordColumn(#"Преобразование", "Value", {"Валюта", "ВалютаID"}, {"Валюта", "ВалютаID"}),
    #"Источник" = Table.RemoveColumns(#"Разверачивание",{"Name"})
in
    #"Источник"

         

        In PowerBI Desktop all works fine. But not in web servise - I cant select gateway for such reports

        As I think cause is in ANY function (including Text.ToBinary) in source string

        Maybe somebody can help me

         

         

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    googlogmob

     

    This is currently not supported. The pattern in question is not supported by static analysis, and cloud refresh does not support dynamic credential flows.

     

    Best Regards,

    Herbert