Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 be ''Invoked function'', ''Invoked function(2)'' , ... etc.
I could always change the table names manually but I would like to have it changed automatically to the name of the table that I gave the function.
Is this possible ?
Thanks in advane for your help
Elijah
Hey guys, has this feature ever implemented?
Any idea?
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
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....
Regards,
Jimmy Tao
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
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
Was support for naming ever implemented?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |