Forum Discussion

omargazzar's avatar
omargazzar
Frequent Visitor
1 year ago
Solved

Power Query - Problem refreshing a report with dynamic data source

Hello all,   I created a PBI report that reads the content of a text file, which has a single URL link that is simply a link to download a csv file. I then managed to create a function that would e...
Need Help
  • omargazzar's avatar
    omargazzar
    1 year ago

    Hey v-saisrao-msft & lbendlin, thank you for all your help. I did ignore the privacy level on the current file, refresh process works normally on Power BI Desktop, but as soon as I upload to Service and try to refresh, I get the same error message on Power BI Service. 

    Happy for you guys to close this thread. It looks like this one just simply can't be resolved with the current restrictions in my organization.

    I'll try exploring more on Power Automation to download the file for me.

omargazzar's avatar
omargazzar
Frequent Visitor
1 year ago

Hi v-saisrao-msft, I am still trying to figure out how to inline my function. I read the provided documentation, but still a little bit confused given that the function gets invoked from another table.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
given that the function gets invoked from another table

that's not what "inline"  means. Don't do that.

  • omargazzar's avatar
    omargazzar
    Frequent Visitor
    1 year ago

    Hey lbendlin, thanks for getting back to me. Do you reckon there is a solution to this problem? The function is meant to open up a link found within a parameter. I added an invoke custom function in my main query that calls that function and passes a specific value through the parameter used in the function.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago
      I added an invoke custom function

      Instead of doing that, inline the function.

      • omargazzar's avatar
        omargazzar
        Frequent Visitor
        1 year ago

        Hey lbendlin, can you please advise how to do that?
        I tried inlining the call function within my main query as shown below and received the following error message.

        from the main query
        = Table.AddColumn(#"Removed Columns1", "CallingFunction", (callFunctionInline) => FunctionInvoker([Original_URL_Link.2.2]))

        Error message for the added invoked custom function

        Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

         

        Any help would be appreciated.