cancel
Showing results for 
Search instead for 
Did you mean: 

Issue - working dashboard now (after getting May update) ...could not load the model schema

The 'send a frown' suggested I post details here: Feedback Type: Frown (Error) Timestamp: 2018-05-25T10:49:07.9847229Z Local Time: 2018-05-25T11:49:07.9847229+01:00 Session ID: 9bca41a5-84be-49e5-82d6-855bce87c1fe Release: May 2018 Product Version: 2.58.5103.501 (PBIDesktop) (x64) Error Message: Couldn't load the model schema. OS Version: Microsoft Windows NT 6.3.9600.0 (x64 en-US) CLR Version: 4.6.1 or later [Release Number = 394271] Peak Virtual Memory: 33.9 GB Private Memory: 275 MB Peak Working Set: 388 MB IE Version: 11.0.9600.18538 User ID: b4185002-0014-44f8-9a2a-f21be65cf88f Workbook Package Info: 1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: DirectQuery Snapshot Trace Logs: C:\Users\npdjvolters\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1837469408.zip Performance Trace Logs: C:\Users\npdjvolters\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_EnableReportTheme PBI_newFromWeb PBI_SpanishLinguisticsEnabled CustomConnectors AdobeAnalytics_UseHierarchicalNavigation PBI_qnaExplore PBI_variationUIChange PBI_canvasTooltips PBI_showIncrementalRefreshPolicy Disabled DirectQuery Options: PBI_DirectQuery_Unrestricted TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Formulas: section Section1; shared PaladinDataset2 = let Source = Sql.Database("localhost", "paladin_db", [HierarchicalNavigation=true]), dbo = Source{[Schema="dbo"]}[Data], PaladinDataset1 = dbo{[Name="PaladinDataset2"]}[Data], #"Changed Type with Locale" = Table.TransformColumnTypes(PaladinDataset1, {{"costofrequestedtreatment", type number}}, "en-US"), #"Changed Type with Locale1" = Table.TransformColumnTypes(#"Changed Type with Locale", {{"paladinsavings", type number}, {"allowance", type number}}, "en-US"), #"Replaced Value" = Table.ReplaceValue(#"Changed Type with Locale1","17","2017",Replacer.ReplaceValue,{"completedateyear"}), #"Filtered Rows" = Table.SelectRows(#"Replaced Value", each true) in #"Filtered Rows";
Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @randyvolters,

 

From your description, you are getting data from SQL database via DirectQuery mode in Power BI desktop, right? 

 

As the error message "Couldn't load the model schema" points out, the issue seems the data couldn't be retrieved. Would you please go to Query Editor and check if any data is retrieved? 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info