Forum Discussion

aoliver's avatar
aoliver
Helper III
7 years ago

Error in data load

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

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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's avatar
      aoliver
      Helper III
      7 years ago

      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