Forum Discussion

elijah2018's avatar
elijah2018
Helper 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
Community 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
Helper 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
    Community 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
      Helper 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