Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I received a request to have a daily email scheduled to send users a CSV export of a table visual in one of my reports. I followed some online guideance to set up a flow using Power Automate and the query copied from running the performance analyzer on the specific table visual.
The remaining challenge is that the headers in the CSV are showing the table name[column name]. The users have requested that only the column name be present. Is there anyway I modidy the query below to alias the header names so they are just ID, Customer Name, Location, and Product Type?
Solved! Go to Solution.
Hi @ERing ,
Your question is actually more of Power Automate than Power BI. When you run a query against a Power BI Dataset in Power Automate, the result always includes the table name and the column. To change the name, you must add another action called Select which you can use to a custom column name onto the table/column/measure. Enter the desired column name in the first column and in the second, write an expression similar to below:
Carpark is the Table while Carpark Number is the column. If referencing a measure, you can write something like @item()?['[Volume]'] where Volume is the name of the measure.
You then need to add another action called Create CSV table where the input is the output from the previous step. The output of this action is what you send to the recepients. For more information, I would suggest you visited the Power Apps forum.
Hi @ERing ,
Your question is actually more of Power Automate than Power BI. When you run a query against a Power BI Dataset in Power Automate, the result always includes the table name and the column. To change the name, you must add another action called Select which you can use to a custom column name onto the table/column/measure. Enter the desired column name in the first column and in the second, write an expression similar to below:
Carpark is the Table while Carpark Number is the column. If referencing a measure, you can write something like @item()?['[Volume]'] where Volume is the name of the measure.
You then need to add another action called Create CSV table where the input is the output from the previous step. The output of this action is what you send to the recepients. For more information, I would suggest you visited the Power Apps forum.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
40 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |