Conexiones de datos, orígenes de datos y cadenas de conexión (Generador de informes y SSRS)

Original URL…

Base de datos de Analysis Services en el servidor localAnalysis Services database on the local server

  • data source=localhost;initial catalog=Adventure Works DW
Anuncios

Converting Dynamics NAV source code from C/AL to AL using PowerShell

Original URL…

Converting from C/AL to AL can be a bit of a hassle:

  • First you need to open den Development Environment
  • Then filter the objects that needs converting
  • Export the objects to a txt file in a folder
  • Then Run the Txt2AL.exe
  • Lastly import them in the workspace

The Script can be downloaded here:

http://ba-consult.dk/downloads/Convert_CAL_AL.zip

Creación de un panel de Power BI desde un informe

Url original…

Ha leído Paneles en Power BI y ahora desea crear los suyos propios.You’ve read Dashboards in Power BI, and now you want to create your own. Hay muchas maneras diferentes de crear un panel: desde un informe, desde cero, desde un conjunto de datos, al duplicar un panel existente, etc.There are many different ways to create a dashboard – from a report, from scratch, from a dataset, by duplicating an existing dashboard, and more. Este tema y vídeo muestran cómo crear un nuevo panel anclando visualizaciones de un informe existente.This topic and video show you how to create a new dashboard by pinning visualizations from an existing report.

NOTA: Los paneles son una característica del servicio Power BI y no de Power BI Desktop.NOTE: Dashboards are a feature of Power BI service, not Power BI Desktop. No se puede crear paneles en Power BI Mobile, pero se pueden ver y compartir.Dashboards can’t be created in Power BI mobile, but they can be viewed and shared.

Vídeo: Creación de un panel con objetos visuales e imágenes anclados desde un informeVideo: Create a dashboard by pinning visuals and images from a report

Vea cómo crea Amanda un nuevo panel anclando visualizaciones de un informe.Watch Amanda create a new dashboard by pinning visualizations from a report. Pruébelo usted mismo, luego, mediante el ejemplo de análisis de adquisiciones y siguiendo los pasos que aparecen debajo del vídeo.Then try it out yourself, using the Procurement Analysis sample, by following the steps below the video.

Importación de un conjunto de datos con un informeImport a dataset with a report

Vamos a importar uno de los conjuntos de datos de ejemplo de Power BI y usarlo para crear el nuevo panel.We’ll import one of the Power BI sample datasets and use it to create our new dashboard. El ejemplo que vamos a usar es un libro de Excel con dos hojas de PowerView.The sample we’ll use is an Excel workbook with two PowerView sheets. Cuando Power BI importa el libro, agregará un conjunto de datos y también un informe al área de trabajo.When Power BI imports the workbook it will add a dataset and also a report to your workspace. El informe se crea automáticamente a partir de las hojas de PowerView.The report is automatically created from the PowerView sheets.

  1. Seleccione este vínculo para descargar y guardar el archivo de Excel del ejemplo de análisis de adquisiciones.Select this link to download and save the Procurement Analysis sample Excel file. Se recomienda guardarlo en OneDrive para la Empresa.We recommend saving it in your OneDrive for Business.
  2. Abra el servicio Power BI en el explorador (app.powerbi.com).Open Power BI service in your browser (app.powerbi.com).
  3. Seleccione un área de trabajo existente o cree una nueva área de trabajo de la aplicación.Select an existing workspace or create a new app workspace.
  4. En el panel de navegación izquierdo, seleccione Obtener datos.From the left nav, select Get Data.

  5. Seleccione Archivos.Select Files.

  6. Navegue hasta la ubicación donde guardó el archivo de Excel del ejemplo de análisis de adquisiciones.Navigate to the location where you saved the Procurement Analysis sample Excel file. Selecciónelo y elija Conectar.Select it and choose Connect.

  7. Para este ejercicio, seleccione Importar.For this exercise, select Import.

  8. Cuando aparezca el mensaje de operación correcta, seleccione la x para cerrarlo.When the Success message appears, select the x to close it.

Abra el informe y ancle algunos iconos en un panelOpen the report and pin some tiles to a dashboard

  1. En la misma área de trabajo, seleccione la pestaña Informes. El informe recién importado se muestra con un asterisco amarillo.Staying in the same workspace, select the Reports tab. The newly-imported report displays with a yellow asterisk. Seleccione el nombre del informe para abrirlo.Select the report name to open it.

  2. El informe se abrirá en Vista de lectura.The report opens in Reading view. Observe que tiene dos pestañas en la parte inferior: “Análisis de descuento” y “Resumen de gastos”.Notice it has two tabs at the bottom: Discount Analysis and Spend Overview. Cada pestaña representa una página del informe.Each tab represents a page of the report.

  3. Mantenga el mouse sobre una visualización para mostrar las opciones disponibles.Hover over a visualization to reveal the options available. Para agregar una visualización a un panel, seleccione el icono de anclaje.To add a visualization to a dashboard, select the pin icon.

  4. Puesto que estamos creando un nuevo panel, seleccione la opción de Nuevo panel y asígnele un nombre.Since we’re creating a new dashboard, select the option for New dashboard and give it a name.

  5. Al seleccionar Anclar, Power BI crea el nuevo panel en el área de trabajo actual.When you select Pin, Power BI creates the new dashboard in the current workspace. Cuando aparece el mensaje Anclado al panel, seleccione Ir al panel.When the Pinned to dashboard message appears, select Go to dashboard. Si se le pide que guarde el informe, elija Guardar.If you’re prompted to save the report, choose Save.

  6. Power BI abre el nuevo panel y aparece un icono: la visualización que acabamos de anclar.Power BI opens the new dashboard and there is one tile – the visualization we just pinned.

  7. Para volver al informe, seleccione el icono.To return to the report, select the tile. Ancle algunos iconos más en el nuevo panel.Pin a few more tiles to the new dashboard. Esta vez, cuando se muestra la ventana Anclar en el panel, seleccione Panel existente.This time when the Pin to dashboard window displays, select Existing dashboard.

Enhorabuena por crear su primer panel.Congratulations on creating your first dashboard! Ahora que tiene un panel, puede hacer mucho más con él.Now that you have a dashboard, there’s so much more you can do with it. Pruebe uno de los Pasos siguientes sugeridos que aparece a continuación o inicie la reproducción y exploración por su cuenta.Try one of the suggested Next steps below, or start playing and exploring on your own.

Sending Electronic Invoice in NAV 2016

Original URL…

We already be able to send invoice as e.g. PDF in mail attachment and it was good feature, but now in NAV 2016 we can do more. We have a really new good feature for invoice sending. Now, we can send business documents electronically. The same situation is for purchase documents; we can receive and convert vendor’s invoices to a purchase invoices in NAV. As document exchange service, we will use external provider. Standard NAV will support sending and receiving electronic invoices and credit memos in the PEPPOL format.

Before we start with using electronic documents, we need to configure Document Exchange Service Setup.

e1

Then, we have to make Document Sending Profile as we need. This is place where we can choose how we want to send our invoice to customer. If we want to send electronic document directly Through Document Exchange Service, you need to set it and then choose format.

e2

After that, we have to add this profile to our customer. Before we send document to our customer, it must have configured VAT Registration No. or GLN. To send document, we have to choose Post and Send on our Sales Invoice and system will send it.

We can also decide to send our sales invoice in electronic format as mail attachment. To do it, we have to configure Document Sending Profile on different way:

e3

Now, when we run Post and Send on our Sales Invoice, system will make an e-mail (every time when we choose Post and Send system will give us possibility to change way of document preparation and sending).

e4

When you see your electronic document, you can see that it is an XML file. You can also choose to save this document on disc or some other possibilities.

e5

Simple table extension to add a new field.

If you are starting to learn development in D365 then understanding the difference between the customization and extensions is something to investigate. Extension being the new concept to allow smaller changes and better hotfixing procedure in production. This is a simple example of creating an extension to add a new field to a table.

D365FO 1611 – Update3 (7.0.4307.16141)

https://player.vimeo.com/video/201936145

In a previous post you can see the process of creating a new model and project.

Creating a new model file

If you are just starting out with D365 or moving from AX2012 then it helps to have a little orientation on where to find things. If you are coming from AX2012 then you will have a lot of basic concepts that still apply in D365 but there are new ways to do things.

When starting development you will need to create a new model. A model can be used to package up the development we are doing so you can later deploy to an environment. To actually do work within Visual Studio you will need to create a project. A project is like any other Visual Studio in that it organizes the items you are working on.

D365FO 1611 – Update3 (7.0.4307.16141)

https://player.vimeo.com/video/191507350

Generate Symbols in a Modern Development environment with Microsoft Dynamics NAV 2018

Original URL…

With the general availability of Microsoft Dynamics NAV 2018 in the first week of December 2017, the new and Modern development environment experience becomes more and more used by developers; side by side with the C/SIDE development environment.

Working with a standard CRONUS database is pretty easy, while every developer would like to give it a spin with their own customized database. In this scenario, it is paramount to have the appropriate symbols generated in order to be successfully pulled out by AL Extension command in Visual Studio Code and develop a custom extension against a proper customized source database.

Installing CSIDE Development Environment side by side with Modern Development Environment is duly described in the docs, as well as how to generate / re-generate symbols. For more information, see https://docs.microsoft.com/en-us/dynamics-nav/developer/devenv-running-cside-and-al-side-by-side.

Here are a few tips that can be helpful when generating symbols.

¿Qué es PowerApps?

Original URL…

¿Qué es PowerApps?What is PowerApps?

PowerApps es una colección de servicios de software y de aplicaciones que funcionan conjuntamente para transformar a nivel fundamental la forma en que se crean y comparten aplicaciones de línea de negocios personalizadas.PowerApps is a collection of software services and apps that work together to fundamentally transform and accelerate how you build and share custom line of business applications.

Introducción animada a PowerApps

PowerApps se conecta a los orígenes de datos y servicios en la nube que ya usa, lo que le permite generar aplicaciones rápidamente que cubren necesidades concretas (basándose en los conocimientos que ya posee).PowerApps connects to the cloud services and data sources you’re already using, giving you the ability to quickly build apps that suit specific needs – building on skills you already have. Puede compartir aplicaciones al instante con sus compañeros de trabajo a través de la Web, de tabletas y de dispositivos móviles.You can share apps instantly with your co-workers across the web, tablets, and mobile devices. PowerApps también se integra con Microsoft Flow, lo que permite desencadenar flujos de trabajo desde las propias aplicaciones.PowerApps also integrates with Microsoft Flow, making it possible to trigger workflows from within apps. PowerApps puede ser rápido y sencillo, capaz de generar una aplicación en minutos que extrae datos de Excel o de un servicio en la nube.PowerApps can be simple and fast – capable of producing an app in minutes that pulls in data from Excel or a cloud service. Pero PowerApps también es estable y orientado a la empresa, y está listo para atender requisitos complejos como el seguimiento de los recursos de una empresa y el enlace a los sistemas back-end.

NAV 2018 and related environment best videos

Original URL…

NAV 2018 What’s New & New Technology – Fast Tracks

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

NAV 2018 What’s New

https://www.slideshare.net/RobertoStefanetti/nav-2018-whats-new

OTHERS

What’s new in Microsoft Dynamics NAV 2018 – A Community Perspective

https://www.youtube.com/watch?v=wK4-hRpoBlQ

NAV 2018 What’s New & New Technology – Fast Tracks

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

What’s new in Microsoft Dynamics NAV 2018 Tenerife

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

NAV 2018 What’s New Video ON DLP (Dynamics Learning Portal)

*** Learning Portal Access is required

 

Microsoft AL & Vs Code

Install Visual Studio Code With Al Compiler

https://www.youtube.com/watch?v=aeE-C3z_qkI

Dynamics NAV – Getting Started With Visual Studio Code

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

AL in Visual Studio VS Code for Those Who are Still Afraid (NAV)

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

Inside AL for Visual Studio Code | Where are we

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

Visual Studio Code – Getting Started with Git(Hub)

https://www.youtube.com/watch?v=NTY5VELbCWI&list=PLhZ3P-LY7CqmxLpyVIPHFYqdqZwuhWQCW

How to create new AL project in VS Code and connect it to NAV

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

Visual Studio Code Building Publishing and Debugging AL Projects

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

How to create new AL project in VS Code and connect it to NAV

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

Dynamics NAV – C/AL vs AL – Spot the Differences

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

Invoking Azure Functions from AL in Visual Studio Code

https://www.youtube.com/watch?v=Wp13-nfVoEg

NAV TechDays 2017: Rock ‘n Roll with VSCode

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

 

POWERSHELL & MULTITENANTS

PowerShell Fundamentals for Beginners

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

How Do I Create PowerShell scripts for Microsoft Dynamics NAV 2013 R2

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

PowerShell 101 by Waldo for Microsoft Dynamics NAV

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

Using PowerShell with Microsoft Dynamics NAV Part 1

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

NAVTechDays2013 Multi Tenancy and how it changes the NAV Developer Experience Microsoft Dynamics Nav

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

Migrate from Multiple Companies to a Multi tenant Architecture in Microsoft Dynamics NAV 2013 R2

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

 

DOCKER

Docker 101: Introduction to Docker

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

Docker Cloud Overview

https://www.youtube.com/watch?v=-Mv6YXrmAzU

Docker and Dynamics NAV – Practical Use Cases

https://www.youtube.com/watch?v=8g82bh5sVTU

NAV TechDays 2017: Easier and DevOps-friendly NAV environments using Docker / Windows Containers

https://www.youtube.com/watch?v=9c5Yl51yXb8

Dynamics NAV 2018 Docker Install

https://www.youtube.com/watch?v=2vXFurYgFQE

 

GIT & GIT HUB

Git 101 – The Basics

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

Visual Studio Code – Getting Started with Git(Hub)

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

Using Git and GitHub

https://www.youtube.com/watch?v=8olbR_Xtg2Q

 

MICROSOFT COGNITIVE SERVICES & AI

Get started with Microsoft Cognitive Services

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

Deep Dive into Azure Cognitive Services

https://www.youtube.com/watch?v=9Nhg469RVc4

Cognitive Services and AI Overview

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

 

APIs

NAV TechDays 2017: Creating great API’s

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

How Do I: use the time series API in Microsoft Dynamics NAV 2017?

https://www.youtube.com/watch?v=8TgsPFz0EAw

Microsoft Azure API Management in under 5 minutes

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