Error in data load

[aoliver]

Hi everyone

I am using a connector created in the SDK of Visual Studio for M language, so I load the data through a .mez file.

In the test of the IDE, its everything OK, but when I try to load the data to a new .pbix file, it throws the next error (in all the queries, not only a few):

I dont have any idea of this error, but the worst thing is:

If after the error I load the data again, its everything OK, No errors.

Any ideas, and how to solve the error?  I cant allow the error in the load data :S

Thanks in advance, Cheers

[TeigeGao]

Hi @aoliver ,

Could you please open the advanced editor to check if exists any error? This problem could be related to character support, we can change the encoding.

Best Regards,

Teige

[aoliver]

@TeigeGao thanks for the answer

If you use the connector to load data via .mez file, you dont have the query in advance editor, you have that in Visual Studio, (and remember that the query brings me the correct output).

Anyways my query in advance editor is as follow:

let
    Source = My.Navigation(),
    k4 = Source{[Key="k4"]}[Data]
in
    k4

Thanks