locked
Problem Combining Queries

    Question

  • I've been trying to follow a technique used by Kasper de Jonge on his blog that takes data from a paginated set of webpages online and combines it into a single query. The full post is here: http://www.powerpivotblog.nl/nba-team-spending-and-their-results-with-excel-powerpivot-and-data-explorer

    The part I'm having trouble with is the function:

    (page) => let
    Source = Web.Page(Web.Contents(“http://espn.go.com/nba/salaries/_/page/” & Number.ToText(page))),
    Data0 = Source{0}[Data]
    in
    Data0

    Previously, that function worked correctly and I was able to reproduce his method. However, that is no longer a  valid expression in Data Explorer. Did something change that would make that invalid?

    The error I receive is "Expression Error: Invalid Identifier" that points to the http line of the Web.Contents function. Can you let me know what I may be doing wrong? Is there a better way to combine paginated webpages into a single query? 


    Monday, June 24, 2013 4:02 AM

All replies

  • Hi,

    I tried the same query and found it is because the quotation marks are not correct. After you copy the query to Data Explorer, please remove these two quotation marks and then re-type them. That should resolve the issue.

    Regards

    Qunshu


    Clarification: Microsoft doesn't own any liability & responsibility for any of my posting.

    • Proposed as answer by Andrew [MSFT] Thursday, June 27, 2013 7:39 AM
    Tuesday, June 25, 2013 11:37 PM