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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 774 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 335 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 248

Last 30 days Overall leaderboard