Can we get data from multiple instance of Business central in Power BI?

[bi_devloper]

Hi All

Is there any way to get data from multiple instance of Business central in Power BI?

for example:  1 Business central is of Singapore Instance  & 1 Business central is of India & other 1 is of Austrailia.

Thanks in Advance!

[Daryl-Lynch-Bzy]

Hi  @bi_devloper - the answer is yes, but you probably need to pull each one separately into a Dataflow and then combine/append the relevant tables from the 3.  This would be cleaner and faster.

[bi_devloper]

Thank You @Daryl-Lynch-Bzy 

Could you please share some links which i can follow as i have never worked with dataflows. Also,please suggest if it requires Premium license to combine & merge the data of different instance in dataflow or pro license will also work?

[Daryl-Lynch-Bzy · Accepted solution]

@bi_devloper - this is a good starting point Creating a dataflow - Power BI | Microsoft Docs

Dataflow a remedy slow data sources in Power BI - YouTube
Streamline Power BI Refresh Refresh dataset after a successful refresh of dataflow - YouTube

This can work in Shared Capacity but it will be slower as the refresh may not start as soon as they are kicked off.

[bi_devloper]

Thank you  so much @Daryl-Lynch-Bzy  for your response. I will work on dataflow & will  get back to you if i face any challenge.