Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have tried to connect to an on premises MS SQL server 2014 in Direct Query mode and get the following error.
When I connect in Import mode it works fine. We need live data for this report. Is there a fix for this?
Mcudogs
Feedback Type:
Frown (Error)
Timestamp:
2017-08-17T00:21:41.5837657Z
Local Time:
2017-08-17T10:21:41.5837657+10:00
Product Version:
2.49.4831.521 (PBIDesktop) (x86)
Release:
August, 2017
IE Version:
11.0.9600.18738
OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)
CLR Version:
4.6.1 or later [Release Number = 394271]
Workbook Package Info:
1* - en-AU, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Peak Working Set:
498 MB
Private Memory:
443 MB
Peak Virtual Memory:
1.22 GB
Error Message:
Couldn't load the model schema.
User ID:
be4e5e95-df02-4aa3-aa20-8926546fece2
Session ID:
008d371b-7782-412f-b12f-92edc940e0d3
Telemetry Enabled:
True
Model Default Mode:
DirectQuery
Snapshot Trace Logs:
C:\Users\namedeleted\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1674684441.zip
Performance Trace Logs:
C:\Users\namedeleted\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
Cloud:
GlobalCloud
Couldn't load the schema for the database model:
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Activity ID:
null
Time:
Thu Aug 17 2017 10:21:29 GMT+1000 (E. Australia Standard Time)
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared #"pxrptuser PROJECT_FULL" = let
Source = Sql.Database("ICTDEVSQL105:56420", "QRPMDB", [CreateNavigationProperties=false]),
pxrptuser_PROJECT_FULL = Source{[Schema="pxrptuser",Item="PROJECT_FULL"]}[Data]
in
pxrptuser_PROJECT_FULL;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.