cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Poma23
Frequent Visitor

Power BI to Excel_ Date Format

Hi , I am trying to export my data from power BI to excel using power automate. I start to create a HTML table with the data from Power BI. Then I create a file and use the data from the HTML table I have. Everything is ok but the date format is like the image bellow and I can not change it in my excel file:

Poma23_6-1626872028345.png

I wanted to use the “Convert time zone” but since I get the whole power BI data in my HTML, I don’t know how to add “Convert time zone” to my date in the new created file. I also tried to add my data from power BI column by column in the HTML file to be able to use the “Convert time zone” but I get an error because my data is not in form of array.

 

Poma23_1-1626871896187.png

Poma23_2-1626871910755.pngPoma23_3-1626871934905.pngPoma23_4-1626871951194.pngPoma23_5-1626872009822.png

Thank you for your time

 

0 REPLIES 0

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,005)