Power Query and SharePoint
Thanks Thanks:  0
Likes Likes:  0
Page 4 of 6 FirstFirst ... 23456 LastLast
Results 31 to 40 of 56

Thread: Power Query and SharePoint

  1. #31
    Board Regular
    Join Date
    May 2015
    Posts
    287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint


    Power Query and SharePoint
    Miguel - I came across something called "PowerPivot for SharePoint 2013" that (I assume) is an add-in specifically for the SharePoint server.

    BUT - yes, you labeled my problem exactly. Everyone has Excel 2013, but what I thought I was creating was a report (with PQ and PP) stored on SharePoint and that they'd be able to view through their browsers. They could access these files two weeks ago with no problem. But as of last week, they started getting errors stating the data in these files can't refresh because it was trying to pull from external sources. I have one simple file using PQ and PP that pulls from a local source - they can open them with no errors. So, that confuses me as to if the problem is with PQ or SharePoint?

    When I searched the information superhighway, there were solutions (see links below), but dealing directly with the SharePoint servers. We are using Office 365, so I suppose we have SharePoint 2013 or an equivalent?

    One solution?

    SharePoint error External Data Refresh Failed:We are unable to refresh one or more data connections in this workbook.The following connections failed to refresh

    Another?

    https://technet.microsoft.com/en-us/.../jj218792.aspx


    Please know I don't claim to completely understand the workings of anything. So, feel free to clarify my situation - i.e. if I need to have reports in SharePoint but no external connections (SalesForce) or whatever. I am completely willing to adjust to the best/most efficient setup.

    Thanks again

  2. #32
    Board Regular
    Join Date
    May 2015
    Posts
    287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    Recap:

    I have source and report Excel documents on SharePoint. I can view any and all of them without incident. My coworkers with whom I'm trying to share the files receive an "External Data Refresh" error whenever they try to open these documents either in Excel Online or in the Desktop version. After searching the web, I discovered this is a known issue - that PQ doesn't seem to work with SharePoint when there are external data sources (btw, my external source is SalesForce). So, I'm not sure the solution.

  3. #33
    Board Regular TimRodman's Avatar
    Join Date
    Jan 2015
    Location
    Columbus, OH
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    The data refresh options are very confusing. Power Query is not the same as a regular Excel data connection. What you can refresh in native Excel is not the same what as what you can refresh in Excel Online. What you can do in Excel Online depends on what version of SharePoint and what add-ons you are running. Even if you are using Office 365 SharePoint, what you can do in Excel Online depends on what version of Office 365 you are using. Microsoft is trying to simplify all of this under PowerBI.com which will go live on July 24th, but we'll have to wait and see if things really do get simpler. So far, they do look very promising.

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

    Default Re: Power Query and SharePoint

    Cmreynolds

    if you have Power Query in your workbooks, you can use Power Update to refresh locally and post direct into SharePoint. Power Update Software -. The software is $500 but I think it is a bargain for what it does.
    Matt Allington is a professional Power BI consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia at https://exceleratorbi.com.au.
    Author of the books Learn to Write DAX and Supercharge Power BI
    What is Power BI?

  5. #35
    Board Regular
    Join Date
    Dec 2012
    Posts
    294
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    cmreynolds,

    For your specific situation, I'd suggest going the Power Update route as well. Your company already bought SharePoint....might as well put it to good use!

  6. #36
    Board Regular
    Join Date
    May 2015
    Posts
    287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    So, Power Update or wait until the PowerBI goes live? Is this just an "upgrade" (term used loosely there) to the current PowerBI? And doesn't PowerBI cost extra, too?

    Again, it's ANOTHER "thing" I have to convince IT to not roll their eyes at me when I say "our company needs this." *sigh*

  7. #37
    Board Regular TimRodman's Avatar
    Join Date
    Jan 2015
    Location
    Columbus, OH
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    Power Update is free for one Excel file to refresh and $500 for unlimited Excel files.

    Power BI pricing can be found here: click here



  8. #38
    Board Regular
    Join Date
    May 2015
    Posts
    287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    My IT just sent me the following link - but it assumes PP for SharePoint is installed and enabled. Maybe this helps? Is it a workaround that allows us not to worry about Power update or Power BI?

    https://msdn.microsoft.com/en-us/lib...ql.110%29.aspx

  9. #39
    Board Regular TimRodman's Avatar
    Join Date
    Jan 2015
    Location
    Columbus, OH
    Posts
    94
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    They can go down that path if they want, but it's not a simple installation. I think that there is a lot of "black magic" involved based on everything that I've read from those who have traveled the path.

    This is why Power Update and Power BI have become popular. You are basically outsourcing the IT complexity.



  10. #40
    Board Regular
    Join Date
    May 2015
    Posts
    287
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query and SharePoint

    I wonder with Power BI - it being billable per user per month - is it billable for ME only? or everyone needing to view the report, you think?

User Tag List

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
  •