Business Intelligence (BI)

Can I use Visual Studio Community in my company to develop Integration Services, Analysis Services, and Reporting Services?

January 10, 2026 9 min read

SQL Server - How to query SQL Server Integration Services Catalog (SSISDB) job execution history

January 3, 2026 6 min read

[Live] - Microsoft Reactor - Fabric Data Days: Prepare for certification exam day

November 3, 2025 8 min read

[In-Person Event] - Microsoft Reactor São Paulo - How to share billion-row reports with thousands of people at low cost

April 25, 2025 5 min read

Power BI Report Server - The local Power BI report server you install on your company server

January 16, 2024 7 min read

Microsoft Fabric (SKU F) - The most economical Power BI license

January 16, 2024 14 min read

Power BI Embedded (SKU A) - Learn more about the license that does not need a PRO account to view reports

January 16, 2024 9 min read

Power BI Premium per Capacity (SKU EM) - The licensing that lets you embed reports in internal applications

January 16, 2024 4 min read

Power BI Premium per Capacity (SKU P) - How the most expensive and complete Power BI license works

January 16, 2024 6 min read

Power BI Premium Per User (PPU) - How this Premium Power BI license works

January 16, 2024 6 min read

Power BI PRO - How the most used Power BI license in companies works

January 16, 2024 7 min read

Power BI Free - How Power BI free licensing works

January 16, 2024 4 min read

[Live 16/10/2023] - Azure Data Factory: ETLs, data pipelines and cloud integrations | Part 3

October 16, 2023 1 min read

Analysis Services - How to monitor the progress of cube processing by SQL Server

August 14, 2023 24 min read

SQL Server - How to reset and recover the SSIS catalog password (SQL Server master key)

August 14, 2023 2 min read

[Live] - SQL Week Recife Conference 5 - Microsoft Fabric: What Changes for BI?

July 26, 2023 1 min read

Analysis Services - How to Change the DeploymentModel Between Multidimensional and Tabular

July 20, 2023 4 min read

Analysis Services - How to Move Cubes and Databases to Another Disk or Directory

July 20, 2023 3 min read

Azure Data Factory (ADF) - How to Change the Service Objective and Resize an Azure SQL Database Using T-SQL Commands

August 13, 2022 5 min read

Live - How to Version and Deploy Power BI Models and Reports with Azure DevOps

June 13, 2022 2 min read

How to Fix SQL Server Data Tools (SSDT) 2017 Installation Error - Setup Failed: Incorrect function (0x80070001)

October 4, 2021 4 min read

Azure Data Factory (ADF) - How to Create Offline Documentation (in CSV) for Your Project

October 3, 2021 10 min read

How to learn SQL / Azure Analysis Services (SSAS / AAS) for free – FOR FREE!

September 21, 2021 5 min read

How to learn Azure Data Factory (ADF) for free - FOR FREE!

September 21, 2021 3 min read

SQL Server Reporting Services (SSRS) - Frozen and Not Starting: Timeout - The Request Failed or the Service Did Not Respond in a Timely Fashion

April 28, 2021 1 min read

Analysis Services - An error occurred while opening the model on the workspace database. Reason: An unexpected error occurred (file 'tmcachemanager.cpp', function 'TMCacheManager::CreateEmptyCollectionsForAllParents')

November 5, 2020 3 min read

Connect-PowerBIServiceAccount : Failed to populate environments in settings

September 17, 2020 2 min read

SQL Server and Power BI - How to Load Stored Procedure Data in SQL Server with DirectQuery

June 16, 2020 7 min read

How to use PowerShell and the API with Agent or SSIS to automate refresh of a Power BI dataset

November 3, 2019 7 min read

SQL Server - Power BI Gateway Problem When Using External IP or Hostname to Access the Database

November 3, 2019 5 min read

Power BI - Now I am a Planilheiro!!

May 18, 2019 2 min read

[Live] - Power BI Service vs Power BI Report Server - 02/27/2019 at 8:30 PM

February 22, 2019 1 min read

[FREE and ONLINE Event] - 02/07/2019 at 8:00pm - Data Architecture and Governance in BI Projects with Power BI

February 6, 2019 1 min read

[FREE and ONLINE Event] - Power BI Web Scraping - Capturing information from MVPs Brasil - 01/24/2019 at 8:30pm

January 23, 2019 1 min read

Power BI - Who are the Microsoft MVPs in Brazil?

December 28, 2018 7 min read

SQL Server Reporting Services (SSRS) - Error Querying Data: There Was a Problem Getting Data from the Report Server Web Service

December 22, 2018 3 min read

SQL Server Reporting Services (SSRS) - Which Reports Are Most Accessed and Which Are Not Being Used

December 22, 2018 5 min read

Video - Power BI vs Reporting Services: Which is better?

October 24, 2018 1 min read

SSRS Reporting Services in Your Company for Free - Meet SQL Server Express with Advanced Services

October 7, 2018 3 min read

SQL Server and Power BI - How to Analyze and Generate Statistics from WhatsApp Group Conversations

August 18, 2018 18 min read

SQL Server Reporting Services (SSRS) - How to Log Report Views and Identify Which User Is Accessing

August 11, 2018 4 min read

SQL Server - Understanding In-Memory OLTP (Hekaton) Tables: Durable vs Non-Durable

June 24, 2018 16 min read

Analysis Services - How to Use XMLA or PowerShell to Process Cubes and Dimensions via T-SQL or SQL Agent Job

August 6, 2017 10 min read

Microsoft MCSA 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Microsoft Excel) free certification exams (beta) until 09/15/2017

July 28, 2017 2 min read

Microsoft MCSE 70-776 certification exam (Performing Big Data Engineering on Microsoft Cloud Services) for free (beta) until 09/08/2017

July 14, 2017 2 min read

Analysis Services - Querying Catalog Views from SQL Server

April 2, 2017 3 min read

Analysis Services (SSAS) - How to Query Information and Process Commands via XMLA Command Line from SQL Server

April 2, 2017 4 min read

Analysis Services - How to Use XMLA for Backup and Restore of Cubes via T-SQL Command Line

March 5, 2017 3 min read

Analysis Services - How to create your first multidimensional cube in the star schema model

February 28, 2017 11 min read

Microsoft MCSE 70-774 Certification Exam (Perform Cloud Data Science with Azure Machine Learning) for free (beta) until 03/31/2017

February 3, 2017 2 min read

Microsoft MCSE 70-775 certification exam (Perform Data Engineering on Microsoft Azure HDInsight) for free (beta) until 03/31/2017

February 2, 2017 2 min read

MCSE 70-773 Certification Exam (Analyzing Big Data with Microsoft R) for free (Beta) until 02/28/2017

January 12, 2017 2 min read

Reporting Services (SSRS) - Error when deleting mobile reports (Error invoking the authorization extension)

December 4, 2016 5 min read

How to Install and Configure Microsoft SQL Server Reporting Services (SSRS) 2016 on Windows Server 2016

December 4, 2016 7 min read

SQL Server Reporting Services - Error Saving Report: System.InvalidOperationException - This Implementation Is Not Part of the Windows Platform FIPS Validated Cryptographic Algorithms

August 11, 2016 4 min read

Analysis Services - Deserialization Failure: The 'AllowedRowsExpression' element in namespace

May 9, 2016 1 min read