Forum Discussion

TomasKincl's avatar
TomasKincl
Frequent Visitor
8 years ago

On Premiss Gateway ODBC error

Hi,   I have trouble to set up ODBC connection to Firebird on  Gateway. My ODBC is connected when I try test connection , its system DSN. Gateway is in server A and dtb Firebird in server B. I have...
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi TomasKincl,

 

Are you able to connect to the DSN with the ODBC connector in Power BI Desktop? :smileyhappy:

 

Regards

TomasKincl's avatar
TomasKincl
Frequent Visitor
8 years ago

Hi v-ljerr-msft,

 

I can see my DSN in ODBC connector (So I can select it) but there is unfortunatelly also error but other one:

"Unexpected error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

 

DSN is connected fine when I test connection via ODBC settings. So it seems to be trouble somethink like Firebird driver + Power BI environment. Really hard to say. Thank you for any recommendation.

 

Best regards,

 

TomasKincl

 

 

  • --staudi--'s avatar
    --staudi--
    New Member
    8 years ago

    Hi @ all!

     

    I have the same error, when trying to connect to my gateway.

    The Issues with the ODBC interface with power bi desktop is fixed now, due to the dec update - thanks for that!

    but now i am not able to connect to my odbc when publishing the files to the dataset

     

    Any ideas?

    THanks in advance

    Philipp

     

     

    Aktivitäts-ID:2141c70f-126f-4201-b2cc-07ed2bb67ebc
    Anforderungs-ID:32adc0e9-bc17-b65c-75cf-2755b3ec5011
      
    Statuscode:400
    Fehlercode:DMTS_PublishDatasourceToClusterErrorCode
    Zeit:Tue Dec 12 2017 08:48:47 GMT+0100 (Mitteleuropäische Zeit)
    Version:13.0.3419.168
    PowerBI:Das Format der Verbindungsdetails ist ungültig.
    • lisa_cummins's avatar
      lisa_cummins
      Regular Visitor
      8 years ago

      I'm getting the same error this morning, any suggestions?

       

      Error:

      Received error payload from gateway service with ID 1408050: Mashup expression evaluation error. Reason: ..

      • viniciusmariano's avatar
        viniciusmariano
        Frequent Visitor
        8 years ago

        Same error here... When the data gateway update will be released???

         

        This is really urgent.

         

        Thanks.

    • hrojasr's avatar
      hrojasr
      Regular Visitor
      8 years ago

      Same error here...