Forum Discussion

vlsooliveira's avatar
vlsooliveira
New Member
1 year ago
Solved

not getting data from data source

Hi everyone!

 

Almost three days in subject and getting no further action to take, I'm hasking for some help.

I created one eventstream, to copy data from our mariadb on premises server to a KQL database, but I'm not getting data no preview.

Since I'm not getting data, I cannot transform the table of my datasouce.

 

 

I have connectivity to server, the schema and the payload are copy to eventstream object, but preview are not working.

 

 

 

Can someone help?

 

Thanks

 

Eventstream
  • vlsooliveira's avatar
    vlsooliveira
    1 year ago

    Hi Brian,

    Thanks for your reply.

    I already discover the issue, unfortunally , not the solution. 

    The problem is on fabric. It's searching for the first binlog file that's not exist.

    Since we are using amazon rds we will get technical support from amazon hope they can help us.

     

    Thanks for your help.

     

    Vladimiro

5 Replies

  • datacoffee's avatar
    datacoffee
    Most Valuable Professional
    1 year ago

    Hi
    It looks like you actually have data in the Eventstream from image number 2 in your question.
    The payload is the actual data in JSON format - if you sink that data in an Eventhouse, you can explode the json with the operator bag_unpack(payload) in your KQL query. bag_unpack plugin - Kusto | Microsoft Learn

    I hope you can make it work 🙂

    \Brian

    • vlsooliveira's avatar
      vlsooliveira
      New Member
      1 year ago

      Hi Brian,

      Thanks for your reply.

      I already discover the issue, unfortunally , not the solution. 

      The problem is on fabric. It's searching for the first binlog file that's not exist.

      Since we are using amazon rds we will get technical support from amazon hope they can help us.

       

      Thanks for your help.

       

      Vladimiro

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    vlsooliveira, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

    datacoffee,  Thanks for your promt response.

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    Hi vlsooliveira, As we haven’t heard back from you, we wanted to kindly follow up to check if the issue resolved? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    Hi vlsooliveira, As we haven’t heard back from you, we wanted to kindly follow up to check if the issue resolved? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query