João Barros

26 Jul 23

Power BI Report Server Configuration and Security Implementation

One of the recent data visualization tools that is being very popular among the customers is Power BI. As the tool is new and Microsoft is enhancing their features day by day, there are issues, a developer could face that has never been encountered earlier. As a developer, I have a chance to work dedicatedly […]

26 Jul 23

Power BI – Finding total number of rows in a table

INTRODUCTION AND USE CASE In PowerBI we can’t select entire the column and see the number of rows in the table. To do this we have to export the data in excel and then we can do it by selecting the column. In the scenario we have a table with different column and when I […]

15 Jul 23

Power BI training contents

Ficheiros e acessos Ferramenta Power BI Desktop Ficheiros para exercícios Ficheiro Feriados Ficheiro 1 Ficheiro 2 Ficheiro 3 Exercicío 1 – Importar dados de um ficheiro de Excel e criar um relatório de Power BI simples Introdução: Importar o “Ficheiro1”, escolha o separador “Sales” e recrie o relatório em baixo. Relatório de exemplo: Exercicío 2 […]

15 Jul 23

Power BI Labs

Access List to Power BI Labs Prepare data in Power BI Desktop Load data in Power BI Desktop Model data in Power BI Desktop, part 1 Model data in Power BI Desktop, part 2 Create DAX calculations in Power BI Desktop, part 1 Create DAX calculations in Power BI Desktop, part 2 Design a report […]

15 Jul 23

PowerBI Best Practices

Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. With Power BI, one can retrieve data from hundreds of data […]

14 Jul 23

Power BI – How to import a Table from SQL Server on-permisses

Power BI – How to import a Table from SQL Server on-permisses On this video you will learn How to import a Table from SQL Server into Power BI Report. If you need to know how to import an Excel sheet to Power BI take a look on this video first. You need help with […]