Unable to open created .pbix report with .csv datasource in other computer

[Anonymous]

Dear Microsoft Representative and fellow Power BI users,

I created a report for my user using a single offline .csv as datasource and sent it to a user (together with the .csv file). When my user opened it, all the visualizations and tables are not diplayed with error notification shown. We have tried to change the datasource in Data Source Settings to the sent .csv and the data has been successfully diplayed in Edit Queries window but still having same issues at the front window.

Have anyone faced same issue? Anyone has solution for me?

I have also checked the permission setting and found no permission has been set.

Below is the detailed error note:

Spoiler

Feedback Type:

Frown (Error)

Timestamp:

2018-02-09T04:02:37.5412969Z

Local Time:

2018-02-09T11:02:37.5412969+07:00

Session ID:

318b6f7e-cf04-443b-a839-45fc911cc62b

Release:

February, 2018

Product Version:

2.55.5010.521 (PBIDesktop) (x86)

Error Message:

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

OS Version:

Microsoft Windows NT 6.1.7601 Service Pack 1 (x86 en-US)

CLR Version:

4.7 or later [Release Number = 461310]

Peak Virtual Memory:

922 MB

Private Memory:

276 MB

Peak Working Set:

353 MB

IE Version:

9.0.8112.16421

User ID:

6adf1bdd-369b-4835-8fe7-fb14a335e652

Workbook Package Info:

1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:

True

Model Default Mode:

Import

Snapshot Trace Logs:

C:\Users\tony010032\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1122464629.zip

Performance Trace Logs:

C:\Users\tony010032\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_EnableReportTheme

PBI_numericSlicerEnabled

PBI_SpanishLinguisticsEnabled

CustomConnectors

PBI_reportBookmarks

PBI_AdobeAnalytics

PBI_qnaExplore

PBI_variationUIChange

PBI_customVisualsGallery

PBI_HanaV2

Disabled DirectQuery Options:

PBI_DirectQuery_Unrestricted

Cloud:

GlobalCloud

Activity ID:

null

Time:

Fri Feb 09 2018 11:02:33 GMT+0700 (SE Asia Standard Time)

Client Error Code:

ServiceErrorToClientError

Error Details:

rsCannotRetrieveModel: An error occurred while loading the model for the item or data source 'OpenConnectionError'. Verify that the connection information is correct and that you have permissions to access the data source.

Stack Trace:

Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'OpenConnectionError'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to open the MSOLAP connection. ---> MsolapWrapper.MsolapWrapperException: Failed to load MSOLAP. Error 87

DPI Scale:

100%

Supported Services:

Power BI

Formulas:

section Section1;

shared #"sungkono data sample" = let

    Source = Csv.Document(File.Contents("C:\Users\tony010032\Downloads\sungkono data sample.csv"),[Delimiter=",", Columns=49, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),

    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"No. Pol", type text}, {"Merk", type text}, {"Tipe", type text}, {"Transmisi", type text}, {"Tipe Detail", type text}, {"Thn", Int64.Type}, {"Warna", type text}, {"Jenis Kend", type text}, {"Kondisi Unit", type text}, {"Km", type number}, {"Tgl STNK", type date}, {"No Rangka", type text}, {"Umur Stock", Int64.Type}, {"harga jual", type number}, {"Discount", type text}, {" harga net jual ", type text}, {" Pot TDP ", type number}, {" Cara Jual ", type text}, {" Kepemilikan ", type text}, {"Tgl. Beli#(lf)[mm/dd/yy]", type date}, {" MRP ", type number}, {" Total GTF Prediksi ", type text}, {" Harga Beli ", type number}, {" Prediksi Matrix GP ", Int64.Type}, {"Total GTF Aktual", type text}, {"Total Komisi Jual", type text}, {"Nilai Stock", type text}, {"Prediksi GP amount", type number}, {"Prediksi GP %", Percentage.Type}, {" GTF Prediksi vs Actual ", type text}, {"Ket Dok", type text}, {"Status", type text}, {"Lokasi", type text}, {"Pemilik Unit", type text}, {"Nama App", type text}, {"Asal", type text}, {"Cab S.O", type text}, {"Ket Kelengkapan", type text}, {"Kode Web", type text}, {" Grade Fix Price ", type text}, {" Tanggal Masuk Rekondisi ", type date}, {" Tanggal Selesai Rekondisi ", type date}, {" Waktu Rekondisi ", Int64.Type}, {" Nama Vendor Salon ", type text}, {" Nama Vendor Body Repair ", type text}, {" Nama Vendor General Repair ", type text}, {" Banyaknya In Out to Vendor ", Int64.Type}, {" Total OI/PDC Exclude PPN ", type text}, {"No. SPK", type text}})

in

    #"Changed Type";

[v-chuncz-msft · Accepted solution]

@Anonymous,

I can not reproduce it with the latest version. You may try to create a support ticket.