Did you know that Microsoft Power BI can connect account schedule data in Microsoft Dynamics 365 Business Central? Follow the simple steps shown below to try this out youself: Click search icon Type Account Schedule KPI Web Service Setup Click Account Schedule KPI Web Service Setup Enter information on General header tab Web Service Name…
One powerful Power BI feature is the ability to import data from multiple files located in a folder. To be able to do this, the files must have the same schema (same number of columns, same datatype, etc.). In this article, we will describe this in more detail. Let suppose we have four sales files,…
We often need to deal with data over a period of weeks, so we’re going to show you how to use Power BI to work with Weeks. Let’s suppose we have a Sales dataset with Date, Category and Revenue columns and we want to see how the sales perform by Week. If we load this to Power BI Desktop, we get a…