{"id":1331,"date":"2018-09-09T22:09:12","date_gmt":"2018-09-09T20:09:12","guid":{"rendered":"https:\/\/data4success.de\/?p=955"},"modified":"2023-08-07T16:23:59","modified_gmt":"2023-08-07T16:23:59","slug":"example-power-bi-from-navision-cost-overview-by-general-account-2","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/example-power-bi-from-navision-cost-overview-by-general-account-2\/","title":{"rendered":"Example Power BI from Navision: Cost overview by G\/L account"},"content":{"rendered":"<p>Here is a small example of how to conjure up a small report from Navision (in the future called \"Microsoft Dynamics 365 Business Central\") using Power BI. This report accesses the general ledger of the accounting department and links the information to the G\/L accounts.<\/p>\n<p><iframe src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiOTVmNjIzYmQtNjUzNi00ZjJkLTk4YzYtOWQzZDVlZDAyYzFiIiwidCI6IjIyMTdmNzdhLWQ4NTMtNDU0ZC1hZWE0LWI1YzE2YTJmOWJhZCIsImMiOjl9\" width=\"800\" height=\"600\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>It becomes especially interesting when you set the time filters dynamically:<\/p>\n<ul>\n<li>If the total result is always that for the current fiscal year<\/li>\n<li>If the monthly result is always the one for the current month (alternatively for the last completed month)<\/li>\n<\/ul>\n<p>Then you can set the report nicely as an email subscription, so you always have all the costs in view.<\/p>\n<p>Are you interested in Business Intelligence in NAV? Then I, Fabian Shirokov, can help you. I automate individual data analysis from Microsoft Dynamics Navision, so you never have to search for data again.<\/p>","protected":false},"excerpt":{"rendered":"<p>Hier ein kleines Beispiel davon, wie man aus Navision (zuk\u00fcnftig &#8222;Microsoft Dynamics 365 Business Central&#8220; genannt) mit Hilfe von Power BI einen kleinen Bericht zaubern kann. Dieser Bericht greift auf das Hauptbuch der Buchhaltung (General Ledger) zu, und verkn\u00fcpft die Informationen mit den Sachkonten (G_L Account). Interessant wird es vor allem dann, wenn man die [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1425,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1331","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-navision"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=1331"}],"version-history":[{"count":0,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1331\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/1425"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=1331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=1331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=1331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}