Fabric Dataflow Gen2's Business Central connector issue

[Shiva123]

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. 

[v-jianpeng-msft · Accepted solution]

Hi, @Shiva123 

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.

[Shiva123]

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 . 

[v-jianpeng-msft · Accepted solution]

Hi, @Shiva123 

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.

[v-jianpeng-msft]

Hi, @Shiva123 

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 (b...

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.

[Shiva123]

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. 

[v-jianpeng-msft · Accepted solution]

Hi, @Shiva123 

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.