Forum Discussion

primolee's avatar
primolee
Helper V
6 years ago
Solved

Calling a function and function name is in a data row

Hello everyone,   Sorry for the repost, I think this is more Power Query related so I am posting here again.   I would like to add a new column which calls pre-made functions, and the name of fun...
Need Help
  • artemus's avatar
    artemus
    6 years ago

    I think I understand what your trying to do now... Don't use Expression.Evaluate, it will just make your life harder. Instead use something like:

    Record.Field(Output, [Processor])([Folder Path] & [Name], [Publisher])
  • artemus's avatar
    artemus
    6 years ago

    Oh I see what is missing...

     

    Change:

     

     

     GoogleGSMDailyProcessor = (fileName as text, publisherName as text) => GoogleGSMDailyProcessor,

     

     

    to

     

     

     GoogleGSMDailyProcessor = (fileName as text, publisherName as text) => GoogleGSMDailyProcessor(fileName, publisherName),

     

     

    Also, if you hit the firewall issue in the online service, go to edit credentialls (for the dataset object, not the report itself) and set "Privacy level setting for this data source" to None

     

artemus's avatar
artemus
Microsoft Employee
6 years ago

You can turn off these checks in the privacy settings in the options menu, if you aren't worried about leaking data from one data source to another.

primolee's avatar
primolee
Helper V
6 years ago

Hello Artemus,

 

I cannot believe how simple this issue can be solved...

 

I changed the global privacy and now data are correctly shown in Power BI Desktop as well!!!!!!  I cannot believe that I was stuck at this for nearly 2 weeks... ðŸ˜†

 

Now the next question is to get on Power BI Service.  As everyone mentioned that #shared will not work in Power BI Service, I will still need to make my own function record.

 

Image 1: with #shared, new column will have the desired table

 

Image 2: with a manually-generated record, column value becomes "Function"

 

Following is my manually-created record "Output":

    Output =
    [
        GoogleGSMDailyProcessor = (fileName as text, publisherName as text) => GoogleGSMDailyProcessor,
        GoogleGSMHourProcessor = (fileName as text, publisherName as text) => GoogleGSMHourProcessor,
        GoogleGDNDailyProcessor = (fileName as text, publisherName as text) => GoogleGDNDailyProcessor,
        GoogleGDNAdGroupProcessor = (fileName as text, publisherName as text) => GoogleGDNAdGroupProcessor,
        GoogleGDNSizeProcessor = (fileName as text, publisherName as text) => GoogleGDNSizeProcessor
    ],

 

Could you please tell me how to use manually-created record and have the correct table value that I want?

 

I think I am almost there.  I am so grateful that both jborro and artemus have been such great help!  Thank you!

 

Best regards,

David