API Date/Time Format Error

[Theandster33]

Hey Everyone, I am 2 days into starting powerbi and have an error I cant seem to work around. 

I am using a power automate code to add a new line of data to an excel sheet everytime someone inputs their info

I am then taking that excel data and feeding it into powerbis API to have live data updates in the report. 

However, I keep getting an error with the "Build start date" format. I have tried "fromatdatetime" command a couple of ddifferent times to work around it and still no luck. Any ideas?

Thanks!

[Theandster33 · Accepted solution]

Of course! Instead of choosing the excel "dynamic content" I replaced it with the sharepoint "dynamic content" icon. 

I also changed the powerbi API code from "date" to "text". 

[Theandster33]

Nevermind I have figured it out lol. Its been a pleasure. 

[Anonymous]

Hi @Theandster33 

I'm sure your solution will help more users who are facing the same or similar difficulties. Can you share your solution? Please mark your reply as ANSWER after sharing. Please feel free to ask me if you have any more questions.

Best Regards,
Yulia Xu