Forum Discussion
Automatically change table names when Query is executed
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
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
- elijah20188 years ago
Helper I
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
- v-yuta-msft8 years ago
Community Support
Hi elijah2018,
I'm afraid power query doesn't have this feature, you can submit your idea here: https://ideas.powerbi.com/.
Regards,
Jimmy Tao
- Anonymous4 years agoNot applicable
Was support for naming ever implemented?