Reconnecting the Dots: Troubleshooting “Unable to Read Data from the Transport Connection” in Power BI. Power BI users have encountered a persistent error during data set refresh, with the message “Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.” This issue has been a cause of […]
This article describes a simple approach that you can apply to improve your reports and dashboards. Effective reports and dashboards should enable users to quickly answer their data questions so that they can focus on their primary business tasks and responsibilities. To help you design effective reports, we introduce the 3-30-300 rule for information design. […]
Have you ever wanted to use Google Fonts in the Power BI text box, highlight text with different colors, or give an option to end-user to change the font size to make the text box more professional with easy-to-understand content? This article explained how to add these functions to your text box with HTML Content […]
Enterprise Data Lake vs Enterprise Data Warehouse, which one is right for you?The enterprise data lake vs enterprise data warehouse conundrum is baffling many organizations. These days almost all large organizations are looking for real-time enterprise data integration to get the most from their data. Petabytes of data reside in legacy databases like SAP, Oracle, […]
If you’ve ever encountered a memory warning while running a query in Power BI Desktop, you know how frustrating it can be. Not only can it slow down the performance of your report, but it can also cause your report to crash. In this article, we’ll explore what causes memory warnings in Power BI Desktop, […]
Power BI is a business intelligence (BI) platform developed by Microsoft. It is a powerful tool that allows users to collect, analyse, and visualise data. Power BI is used by businesses of all sizes to make better decisions. In 2023, the growth of Power BI is expected to be driven by five major trends: The […]
A special case of the PARALLELPERIOD function: NEXTYEAR, NEXTQUARTER, NEXTMONTH and NEXTDAY — create a column with dates of the previous year, quarter, month and day. creating a column with the dates of the next year, quarter, month and day. PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH and PREVIOUSDAY — creation of a column with the dates of of […]
Data analytics is the process of storing, organising, and analysing raw data to answer questions or gain important insights. Data analytics is integral to business because it allows leadership to create evidence-based strategy, understand customers to better target marketing initiatives, and increase overall productivity. Companies that take advantage of data analytics reap a competitive advantage […]
