Forum Discussion

DiePic's avatar
DiePic
Resolver II
4 years ago
Solved

Connect dbase BC365 in the cloud

I'm new in power bi and power query. I need to connect a BC365 envronment that is no more on premise but in cloud, to create a dashboard with my personal query between tables resources-customers-tim...
Need Help
Show and Tell
Tips and Tricks
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, DiePic ;

There are basically 3 things you need in order to get the beautiful Power BI dashboard with the data from your Dynamics 365 Business Central:

  1. Subscription to Office 365 and Dynamics 365 Business Central
  2. Name of the company that you want to display in the Power BI dashboard
  3. Name of the database that you want to connect the Power BI dashboard

Connecting Power BI to Dynamics 365 Business Central in 2 minutes - Confessions of a Dynamics 365 Business Central Consultant (apcommerce.com)

Building Reports in Power BI Desktop to Display Business Central Data - Business Central | Microsoft Docs


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DiePic's avatar
    DiePic
    Resolver II
    4 years ago

    thanks for replay v-yalanwu-msft , all solution are perfect and is working.
    But what I will is to connect on BC365 and insert a my "personal query", not using API or On-line services ... I read a lot on this and I have come to the conclusion that it's not possible, I must use on-line services for my needs .... it's correct?