Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Fabric Dataflow Gen2's Business Central connector issue

Hi All, 

I am trying to pull the Business Cental data into Fabric Dataflow Gen2. I logged in with the same credentials, and I tried. The connection is established, but the data is not showing. I am just attaching a screen shot. Please, anyone, help me. 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

    Thank you for your reply. Are you able to create dataflow gen1 to connect to your table in Business Central?

    In addition, here is an alternative solution:
    Use Business Central connector to connect to Business Central in Power BI desktop, and then copy the M code in the advanced editor of PowerQuery. When creating the dataflow. Select to create a new blank query and paste the copied M code into it.

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

    If you've already addressed the current issue, you can mark a helpful reply as a solution so that other members of the community can quickly find a solution.

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    Please check if the following is set to true. In addition, please make sure that your current credential account has the permission to read data in Business Central.

    You can learn how to connect Dataflow Gen2 to Business Central by reading the following article:

    Let’s flow your Business Central data into Microsoft Fabric - Discover Microsoft Business Central (bertverbeek.nl)

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, Jianpeng Li, 

      Thanks for the replay. I followed the same article that you shared. Steps also I followed, then only I am getting that issue, which I showed above. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, Anonymous 

        Thank you for your reply. Are you able to create dataflow gen1 to connect to your table in Business Central?

        In addition, here is an alternative solution:
        Use Business Central connector to connect to Business Central in Power BI desktop, and then copy the M code in the advanced editor of PowerQuery. When creating the dataflow. Select to create a new blank query and paste the copied M code into it.

         

         

        Best Regards

        Jianpeng Li

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Jianpeng Lii, 

    Thanks; I did not try that dataflow in Gen 1. Yes, same method I implemented. Took power bi desktop there, loaded required tables, copied M code, and pasted in Dataflow Gen2 blank query there, it is working fine. 

     


    Thanks and Regards 
    Shiva . 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, Anonymous 

      If you've already addressed the current issue, you can mark a helpful reply as a solution so that other members of the community can quickly find a solution.

       

      Best Regards

      Jianpeng Li

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.