Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Quentin
Helper III
Helper III

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

1 ACCEPTED SOLUTION
Quentin
Helper III
Helper III

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!

View solution in original post

6 REPLIES 6
Quentin
Helper III
Helper III

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!

Thanks for letting everyone know, a good find!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Quentin
Helper III
Helper III

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...)
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...

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

Hi @Quentin 

 

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

 

Check to see if Custom visuals are allowed?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors