couldn't retrieve the data for this visual in Power Bi Desktop

[Yasser_Gawad]

couldn't retrieve the data for this visual in Power Bi Desktop

try again later

[v-qiuyu-msft]

Hi @Yasser_Gawad,

Please follow below steps to troubleshoot the issue:

1. Which data source did you get data from? Please open Query Editor and click Refresh Preview button to make sure all queries can return data successfully.

2. Did you create any measures or calculated columns displayed in this visual? If so, check DAX formula.

3. Please make sure you are running latest desktop version.

If issue persists, please share more information with us to analyze the issue.

Best Regards,
Qiuyun Yu

[Yasser_Gawad]

The source date from excel sheet

there's no formula at all

I'm using the latest version

Version: 2.43.4647.541 64-bit (Feb, 2017)

Many Thanks

[Phil_Seamark]

How did you get on with this?  Was there an error message on the Visual?

[Yasser_Gawad]

Just after draging any field to visual an error apper 

Can't display the visual. See detail 

and the details is :

couldn't retrieve the data for this visual in Power Bi Desktop

[Julien_Verger]

Using the latest version availbale of Power BI Desktop (2.44.4675.422 32-bit (march 2017)), I have the same error message except I am loading the dataset from a CSV file.

• the data are successfully loaded
• I have some calculated columns without DAX errors 

Below, this is the details of the error :

Feedback Type:
Frown (Error)

Timestamp:
2017-03-07T14:14:11.5499100Z

Local Time:
2017-03-07T15:14:11.5499100+01:00

Product Version:
2.44.4675.422 (PBIDesktop) (x86)

Release:
March, 2017

IE Version:
11.0.9600.18537

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 fr-FR)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
1* - fr-FR, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
243 MB

Private Memory:
291 MB

Peak Virtual Memory:
1.08 GB

Error Message:
Couldn't retrieve the data for this visual. Please try again later.

User ID:
87d9540a-9088-4ff1-9a6e-c49b8434a567

Session ID:
fcf4a611-ccd8-4b3b-a8cd-fbaf9e4f7234

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\JPDZ8005\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot710956402.zip

Performance Trace Logs:
C:\Users\JPDZ8005\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_RedShift
PBI_Impala
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_esriEnabled
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled

Disabled DirectQuery Options:
DirectQuery_Unrestricted

Cloud:
GlobalCloud

Activity ID:
fcf4a611-ccd8-4b3b-a8cd-fbaf9e4f7234

Time:
Tue Mar 07 2017 15:14:09 GMT+0100 (Paris, Madrid)

Version:
2.44.4675.422 (PBIDesktop)

Error Code:
rsDataShapeProcessingError

OData Error Message:
Failed to open the connection.

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared glpi = let
Source = Csv.Document(File.Contents("C:\WORKSPACES\UDEV\PICHET\doc\glpi\glpi.csv"),[Delimiter=";", Columns=13, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"En-têtes promus" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"En-têtes promus";