Forum Discussion

Javier-Fraile's avatar
Javier-Fraile
New Member
3 years ago

Error refreshing my report - but same source file works fine as excel

I am feeding a report in 2 different ways just for testing purposes: Mode 1 - Excel source as a local file. This one works fine. Mode 2 - Same excel source in a Teams folder. Using SharePoint sourc...
error
Refresh
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Are you connecting to sheets or tables ?

  • Javier-Fraile's avatar
    Javier-Fraile
    New Member
    3 years ago

    Hi Ibendlin,

    Thanks for your response.

    Let me add that this morning for the first time I could complete the refresh of the excel sheet located on sharepoint successfully.

    The transform File states this, so I guess it's a Sheet.

     

    = (Parameter1 as binary) => let
    Source = Excel.Workbook(Parameter1, null, true),
    #"DSS All Opportunities >2019 SPM_Sheet" = Source{[Item="DSS All Opportunities >2019 SPM",Kind="Sheet"]}[Data]
    in
    #"DSS All Opportunities >2019 SPM_Sheet"

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      If it is a sheet then it is your responsibility to indicate to Powr Query how to classify each column - after you promoted the headers.

      • Javier-Fraile's avatar
        Javier-Fraile
        New Member
        3 years ago

        Yes, I just led the system promote the columns as the names as well.
        Right now I've just refreshed the report for the second time and it ended successfully, I'd say this is resolved.