By Justin Song August 31, 2021

Account Schedule With Power BI in Dynamics 365 Business Central

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…

By insightsoftware May 21, 2018

How to Load Data from a Folder in Power BI

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,…

By insightsoftware May 7, 2018

Working with Weeks in Power BI

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…

1 / 1