BI Migration or Connecting with Dynamic 365 Business Central

[Anonymous]

Hello Everyone,

our company has been working on Dynamic NAV so far now they are moving to Business Central and i have developed all the reports on Power BI, now they are asking me connect Power BI with business central, i really have no idea,  how can i do it? they want when users open business central like sales team, finance & accounting users login on business central then they can see power BI reports there...

Can anyone has any idea how can i connect them to business central and if i successfully do connect it then do i have to develop all the reports of power BI once again on business central or the same datasets will work there...????

Kindly Help

Thanks & Regards,

Arif

[v-xicai]

Hi @Anonymous   ,

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[amitchandak]

@Anonymous ,

refer

https://help.lscentral.lsretail.com/Content/Dynamics%20NAV/across-how-to-connect-powerbi-dynamics-365-content-packs-help.html

https://www.youtube.com/watch?v=apZjCHOjxa4

https://www.youtube.com/watch?v=lx8fZAxzwLc

[pranit828]

HI @Anonymous 

Use the below link to access business central data.

https://help.lscentral.lsretail.com/Content/Dynamics%20NAV/across-how-to-connect-powerbi-dynamics-365-content-packs-help.html

You don't have to develop teh reports again as long as you get teh same set of columns for the dataset.

In teh power Query editor go to advance query and update just the data source .

[Anonymous]

thank you for your reply, i really appriciate it but can you please tell me, like you said that all i need to do instead of redeveloping all the reports i need to change the datasource from the query editor but what if the they change the data source from SQL Server to Azure datasoruce then can i do the same?

[v-xicai]

Hi @Anonymous ,

The article shows that you may get Microsoft Dynamics 365 Business Central content pack from Power BI Service, and it doesn't show you can achieve the demand by changing the data source in Query Editor.

Best Regards,

Amy 

Community Support Team _ Amy

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