Forum Discussion

Mopyd's avatar
Mopyd
Regular Visitor
9 years ago

Error when i refresh data in PowerBi Desktop

I am not sure how to debug these errors. Is there a log to view? Unless someone has any idea as to what it is. In the applied steps i deleted "reordered columns", "kept errors", "added index" then applied and closed. Still getting the issue. Any help would be great!

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    In the left Queries pane of the 'Edit Queries' window, there will be a new query that will have a dated log of that error report.  It will operate similar to the other power queries you have, where you can step through it and see what is wrong.

    EDIT:  Actually i can see it in your screenshot.  Look at the very top query.

    • Mopyd's avatar
      Mopyd
      Regular Visitor
      9 years ago

      So this is the query (when i open advanced editor)

       

      let
      Source = #"labtech v_xr_computers",
      #"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
      #"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"UserID", "ReportCompanyName", "ClientID", "ClientName", "ClientCompany", "ClientArea", "LocationID", "LocationName", "LocationArea", "ComputerID", "ComputerName", "ComputerFriendlyName", "ComputerRoles", "ComputerFormFactor", "ComputerIsServer", "ComputerIsVirtual", "ComputerChassisType", "ComputerOSType", "ComputerOS", "ComputerServicePack", "ComputerServicePackName", "ComputerOSFullVersion", "ComputerAssetTag", "ComputerSerial", "ComputerManufacturer", "ComputerModel", "ComputerMAC", "ComputerLocalIP", "ComputerRouterIP", "ComputerDomain", "ComputerDNSInfo", "ComputerLTVersion", "ComputerDateOSStart", "ComputerDateAddedLT", "ComputerDateLastContact", "ComputerUsername", "ComputerUptime", "ComputerCPUSpeed", "ComputerCPUUsage", "ComputerRAMSize", "ComputerRAMFree", "ComputerDriveSize", "ComputerDriveFree", "ComputerShares", "ComputerFlags", "ComputerContactID", "ComputerContactName", "ComputerContactArea", "ComputerAVScannerName", "ComputerAVAPSetting", "ComputerAVVirusDefs"}),
      #"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "UserID", "ReportCompanyName", "ClientID", "ClientName", "ClientCompany", "ClientArea", "LocationID", "LocationName", "LocationArea", "ComputerID", "ComputerName", "ComputerFriendlyName", "ComputerRoles", "ComputerFormFactor", "ComputerIsServer", "ComputerIsVirtual", "ComputerChassisType", "ComputerOSType", "ComputerOS", "ComputerServicePack", "ComputerServicePackName", "ComputerOSFullVersion", "ComputerAssetTag", "ComputerSerial", "ComputerManufacturer", "ComputerModel", "ComputerMAC", "ComputerLocalIP", "ComputerRouterIP", "ComputerDomain", "ComputerDNSInfo", "ComputerLTVersion", "ComputerDateOSStart", "ComputerDateAddedLT", "ComputerDateLastContact", "ComputerUsername", "ComputerUptime", "ComputerCPUSpeed", "ComputerCPUUsage", "ComputerRAMSize", "ComputerRAMFree", "ComputerDriveSize", "ComputerDriveFree", "ComputerShares", "ComputerFlags", "ComputerContactID", "ComputerContactName", "ComputerContactArea", "ComputerAVScannerName", "ComputerAVAPSetting", "ComputerAVVirusDefs"})
      in
      #"Reordered Columns"

       

      Not sure what the error is though. Or what it is trying to tell me to fix. My repot is still updating but the refresh still gets the same error. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        When you click on the error log queries, look into the Data view and look out for the fields with "Error" in them.  Clicking on the error gives you error messages.