Forum Discussion

elijah2018's avatar
elijah2018
Icon for Helper I rankHelper I
8 years ago

Automatically change table names when Query is executed

Hi everyone,    So I gather data using a function in Power Query that has as an input the table name of the table I want to download.  The problem that I have is that the resulting table name will...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi elijah2018 ,

 

Please check if you have create a table or just a custom function. If you have create a table, you can rename it by click "Source" step and change the name. If you have create a custom function, there's no table exists. If you still have doubt, for further analysis, could you post your table structure or custom function in your PBIX?

 

Regards,

Jimmy Tao

  • elijah2018's avatar
    elijah2018
    Icon for Helper I rankHelper I
    8 years ago

    Thank you Jimmy ( v-yuta-msft ) for your interest in helping me. 
    I am very new to Power BI and  have probably just created a custom function and therefore not created a real table.
    I will try to explain what I have created. 

     

    I have a function called GetData having the following structure; 

     

    let
    Source = (datapoint as text) as table =>

        let
        Source = Csv.Document(Web.Contents("www.mydatasource.com/" & datapoint),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])
       in Source

    in
    Souce

    So the function takes datapoint as argument and downloads the content using Web.Contents. 
    The result is a table (?) called invoked function and if I rename the table I cant see any code generated in the ''advance editor'' . 

    What am I doing wrong ? 


    Thanks again

    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi elijah2018,

       

      Here are my steps:

      1. Create a blank query and paste your code, then apply. This is a function which can be invoked, not a table.

      2. Input parameter (e.g.: "products.html") then click invoke, the function can generate a table, then right click on the table and you can rename it.

       

      See screenshots and PBIX here: https://www.dropbox.com/s/69844sipmc6rqfg/Automatically%20change%20table%20names%20when%20Query%20is%20executed.pbix?dl=0.

       

       

      Regards,

      Jimmy Tao

      • elijah2018's avatar
        elijah2018
        Icon for Helper I rankHelper I
        8 years ago

        Hi again Jimmy ( v-yuta-msft ), 

        What I would like to do is to skip the ''click on the table to rename it step'' . I would like Power Query to automatically change the name of the table to for e.g the datapoint I had as an input to the function. 

         

        Is this possible ? 

         

        Regards

        Elijah