Any kind of data cource loading is stuck on Load / Loading data to model

[TeamwayDev]

Hi everyone !

I am using a fresh update of Power BI (Version: 2.112.1161.0 64-bit (décembre 2022)) Desktop with default settings.

I tried several very simple data import ( custom REST API, Sharepoint List content, SharePoint Folder content, CSV file upload).

All of those sources have very simple data models and few entries.

All of them works fine and give me the expected results in the Power Query Editor.

When I Close & Apply, all of them have the same behavior :

The "Load" popup displays the loading process, and get stuck forever on the "Loading data to model" step.

Is there anything I am doing wrong ?

What can I do to investigate what is going wrong ?

Here is the output of my Power BI session diagnostics on the csv file import attempt:

Feedback Type:
Frown (Error)

Timestamp:
2023-02-08T08:59:26.3463611Z

Local Time:
2023-02-08T09:59:26.3463611+01:00

Session ID:
47a5217e-cb22-4589-910d-826e61e4e18b

Release:
December 2022

Product Version:
2.112.1161.0 (22.12) (x64)

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 fr-FR)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
70.6 GB

Private Memory:
612 MB

Peak Working Set:
674 MB

IE Version:
11.789.19041.0

User ID:
00ffd8eb-8c8f-4b04-9caa-625b43393522

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\JulienMAGNE\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShotd8c96ad7-08e0-4f47-ad29-b309832ac214.zip

Model Default Mode:
Empty

Model Version:
PowerBI_V1

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

Enabled Preview Features:
PBI_enableWebView2
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_NlToDax
PBI_optimizeTabRibbon
PBI_relationshipEditPane

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared Export_Users = let
Source = Csv.Document(File.Contents("C:\Users\[...]\Export_Users.csv"),[Delimiter=",", Columns=20, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"id", Int64.Type}, {"username", type text}, {"email", type text}, {"firstname", type text}, {"lastname", type text}, {"language", type text}, {"phonenumber", Int64.Type}, {"avatar", type text}, {"role", type text}, {"type", type text}, {"rhid", type text}, {"idpartner", type text}, {"state", type text}, {"sso", type logical}, {"suspenddate", type text}, {"creationdate", type datetime}, {"modificationdate", type datetime}, {"lastlogindate", type datetime}, {"groups", type text}, {"Groupe", type text}})
in
#"Changed Type";

[v-yetao1-msft]

Hi @TeamwayDev 

Did you test these data sources together or separately when you tested them? If you test these data sources separately, does it appear to load all the time?

Best Regards,
Community Support Team _ Ailsa Tao

[TeamwayDev]

I tested also separately and had the same behavior.

I downgraded Power BI Desktop to Version: 2.107.841.0 64-bit (juillet 2022) and evrything is working fine.