web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / No option available to...
Power Apps
Answered

No option available to create power query template from excel

(0) ShareShare
ReportReport
Posted on by 27

I am preparing for PL400. I am on this following page and trying to create a Power Query template. I don't see any option for this 2nd point: Once Power Query loads, select File > Export Template

Generate a new dataflow from an Excel Template - Training | Microsoft Learn

 

ravdemo_0-1703397480293.png

 

Thank you

I have the same question (0)
  • Verified answer
    gulshankhurana Profile Picture
    1,397 Moderator on at

    Hi @ravdemo 

     

    This is because the Template Export is only available to Microsoft 365 Insiders (previously known as Office Insider program).

     

    gulshankhurana_0-1703458279852.png

     

    Please find more information in the following link:

    Solved: Exporting queries in Excel to a Power Query templa... - Power Platform Community (microsoft.com)

     

    Although the thread above is quite old but it still holds true and has a link to the M365 Insider program information.

     

    If my response helps with your query then please accept it as a solution. If you appreciate my efforts then please give it a Thumbs Up too.

     

    Kind regards

    Gulshan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard