Forum Discussion

Quentin's avatar
Quentin
Helper IV
5 years ago
Solved

Difference in Refresh data between desktop and service

I have a report with 2 conectors: Sharepoint list (10 lists) and Sharepoint Conector, credencial OAuth2 level of security private

When i actualize in PowerBi Desktop, everything's fine

When i publish in the server, everything's fine

When i refresh the dataset in PowerBi Service, credencial OAuth 2 security level private, it only shows part of the info

 

I cannot explain it to m

Need Help
  • Quentin's avatar
    Quentin
    5 years ago

    Dear GilbertQ and anyone who comes accros this...
    Thank for the response i found the error but it couldnt be found by the indication i was giving.
    Let's all be aware that Desktop and Service do not read sharepoint list exactly in the same way!

    While on desktop a True/False column in a sharepoint list was read "TRUE" or "FALSE" and it works to make measures on condition ="TRUE", the service reads it as 1 or 0 and therefore the measure do not return the same value, giving the impression the actualization takes part of the data....

    I spent 2 days on it looking at the wrong direction... 😞 
    Thanks again for participation and guidance!

6 Replies

  • Quentin's avatar
    Quentin
    Helper IV
    5 years ago

    Dear GilbertQ and anyone who comes accros this...
    Thank for the response i found the error but it couldnt be found by the indication i was giving.
    Let's all be aware that Desktop and Service do not read sharepoint list exactly in the same way!

    While on desktop a True/False column in a sharepoint list was read "TRUE" or "FALSE" and it works to make measures on condition ="TRUE", the service reads it as 1 or 0 and therefore the measure do not return the same value, giving the impression the actualization takes part of the data....

    I spent 2 days on it looking at the wrong direction... 😞 
    Thanks again for participation and guidance!

    • GilbertQ's avatar
      GilbertQ
      Super User
      5 years ago

      Thanks for letting everyone know, a good find!

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Quentin 

     

    I would make sure that the privacy settings on your datasources are set to NONE in Power BI Desktop.

     

    Then when you publish to the Power BI Service and you have to set the credentials for oAuth2 make sure that the privacy setting there is also set to NONE.

  • Quentin's avatar
    Quentin
    Helper IV
    5 years ago

    When publishing it it tells me there was a problem in vizualising or... is it due to that? 
    Here are the details of the error... i don't get it

    Feedback Type:
    Frown (Error)

    Timestamp:
    2021-02-02T00:47:45.8214598Z

    Local Time:
    2021-02-02T01:47:45.8214598+01:00

    Session ID:
    f7f909fe-4470-4b20-aff2-f49b646d6331

    Release:
    December 2020

    Product Version:
    2.88.1385.0 (20.12) (x64)

    Stack Trace:
    (at https://dev.virtualearth.net/webservices/v1/LoggingService/LoggingService.svc/Log?entry=0&fmt=1&type=3&group=MapControl&name=MVC&version=v8&mkt=es-ES&auth=AoW85FdF-eTJavFmWhZjaQ970kwG1FuainbyVSlP5HglkbhVVIFOyNwlaQxAIj-S&jsonp=Microsoft.Maps.NetworkCallbacks.f_logCallbackRequest:line:1:33)
    TypeError: Microsoft.Maps.NetworkCallbacks.f_logCallbackRequest is not a function
    at https://dev.virtualearth.net/webservices/v1/LoggingService/LoggingService.svc/Log?entry=0&fmt=1&type=3&group=MapControl&name=MVC&version=v8&mkt=es-ES&auth=AoW85FdF-eTJavFmWhZjaQ970kwG1FuainbyVSlP5HglkbhVVIFOyNwlaQxAIj-S&jsonp=Microsoft.Maps.NetworkCallbacks.f_logCallbackRequest:1:33

    PowerBINonFatalError:
    {"AppName":"PBIDesktop","AppVersion":"2.88.1385.0","ModuleName":"","Component":"","Error":"TypeError","MethodDef":"","ErrorOffset":"-1:-1"}

    OS Version:
    Microsoft Windows NT 10.0.18362.0 (x64 es-ES)

    CLR Version:
    4.7 or later [Release Number = 528040]

    Peak Virtual Memory:
    39.1 GB

    Private Memory:
    1.36 GB

    Peak Working Set:
    1.51 GB

    IE Version:
    11.900.18362.0

    User ID:
    a2675be8-37e9-480c-b3ea-f0f58721ac3f

    Workbook Package Info:
    1* - es-ES, Query Groups: 12, fastCombine: Enabled, runBackgroundAnalysis: True.

    Telemetry Enabled:
    True

    Model Default Mode:
    Import

    Model Version:
    PowerBI_V3

    Is Report V3 Models Enabled:
    True

    Enabled Preview Features:
    PBI_shapeMapVisualEnabled
    PBI_SpanishLinguisticsEnabled
    PBI_NewWebTableInference
    PBI_v3ModelsPreview
    PBI_azureMapVisual
    PBI_dataPointLassoSelect
    PBI_narrativeTextBox
    PBI_dynamicParameters

    Disabled Preview Features:
    PBI_JsonTableInference
    PBI_ImportTextByExample
    PBI_ExcelTableInference
    PBI_qnaLiveConnect
    PBI_eimInformationProtectionForDesktop
    PBI_compositeModelsOverAS
    PBI_anomalyDetection
    PBI_newFieldList
    PBI_cartesianMultiplesAuthoring

    Disabled DirectQuery Options:
    TreatHanaAsRelationalSource

    Cloud:
    GlobalCloud

    DPI Scale:
    150%

    Supported Services:
    Power BI

    • GilbertQ's avatar
      GilbertQ
      Super User
      5 years ago

      Hi Quentin 

       

      That error appears to be from a Custom Visual and not a dataset refresh.

       

      Check to see if Custom visuals are allowed?

      • Quentin's avatar
        Quentin
        Helper IV
        5 years ago

        Thank you again for your support and help, very much appreciated!
        There are no costum visual in this report... it's the choroplet visual from Bing that seems to be the problem so i tried another visual (ArcGis Map) but still faced the same issue of showing only part of the data when refreshed from the PowerBi Service
        Until i find a solution i published it with manual refresh from the desktop but it's crealry not the solution