Results 1 to 10 of 10

Thread: Power View activated but no tab on ribbon
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Power View activated but no tab on ribbon

    I am using Excel 2013 and have Power Pivot, Power Query and Power View activated.

    There is a tab on the ribbon for both Power Pivot and Power Query, but none for Power View.

    When I go into File > Options > Customize Ribbon, there is a tab in the list of Main Tabs under 'Customize the Ribbon' for all three apps, and the box next to each is checked.

    How do I get the Power View tab onto the ribbon?

  2. #2
    Board Regular ParamRay's Avatar
    Join Date
    Aug 2014
    Location
    England, UK
    Posts
    1,193
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    Power View used to be on the Insert tab, within a group called Reports. But they've removed it by default now, presumably because we're supposed to use Power BI for visualizations instead.

    You can add it back to the Ribbon though. If you go to Customize Ribbon and choose Commands Not in the Ribbon, the command you need to add is called Insert a Power View Report.

  3. #3
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    You are right, but it is not because you are "supposed" to use Power BI. Power View was effectively the prototype of Power BI. Power View is like version 0.1 and Power BI is currently in version 2.0.

    I wouldn't use Power View because it is old and extremely limited in capabilities.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  4. #4
    Board Regular ParamRay's Avatar
    Join Date
    Aug 2014
    Location
    England, UK
    Posts
    1,193
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    You're not the guy who wrote the book, are you? Or perhaps just the same name.

  5. #5
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    Quote Originally Posted by ParamRay View Post
    You're not the guy who wrote the book, are you? Or perhaps just the same name.
    Yes, I'm the guy that wrote the book
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  6. #6
    Board Regular ParamRay's Avatar
    Join Date
    Aug 2014
    Location
    England, UK
    Posts
    1,193
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    Quote Originally Posted by Matt Allington View Post
    Yes, I'm the guy that wrote the book

    Big respect. Love that book. Best one out there for learning.

    Can you write an accompanying book with practice exercises?

  7. #7
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    I'm glad you like it. I always appreciate a review on Amazon if you have a few minutes to spare.

    What would the accompanying book be about? Are you saying same topic but more exercises (more than the original), or some other topic?
    Last edited by Matt Allington; Jul 10th, 2017 at 03:23 AM.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

  8. #8
    Board Regular
    Join Date
    Sep 2013
    Posts
    118
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    Last edited by citizenbh; Jul 10th, 2017 at 04:29 AM.

  9. #9
    Board Regular ParamRay's Avatar
    Join Date
    Aug 2014
    Location
    England, UK
    Posts
    1,193
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    Quote Originally Posted by Matt Allington View Post
    I'm glad you like it. I always appreciate a review on Amazon if you have a few minutes to spare.

    What would the accompanying book be about? Are you saying same topic but more exercises (more than the original), or some other topic?
    Perhaps a book that uses a different data source (other than AdventureWorks) and has a number of test questions asking you to write different measures. Kind of like to test your knowledge. And then an answer section at the back. Appreciate your book already has lots of exercises, but you can never have enough practice!

  10. #10
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power View activated but no tab on ribbon

    Books are remarkably unprofitable (unless you are JK Rowling), so another is not high on my list . I will refresh my current book to a second edition however. (Refresh - not rewrite)
    Last edited by Matt Allington; Jul 13th, 2017 at 05:44 PM.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •