Tag Archives: power bi

“Unable to connect” error when accessing SQL database in Power BI Desktop

“Unable to connect” error when accessing SQL database in Power BI Desktop

When attempting to access a SQL server/database in Power BI, you might get the following error message: Unable to connect We encountered an error while trying to connect. Details: “An error happened while reading data from the provider: ‘Could not load file or assembly ‘System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=….. Error message received when trying to get […]

Solution: “An error occurred while attempting to save the report to Power BI Report Server”

Solution: “An error occurred while attempting to save the report to Power BI Report Server”

Symptoms Did you recently download a newer version of Power BI Desktop (optimized for Report Server)? The latest is August 2018 as of the writing of this post. If you’ve downloaded August and are trying to save to an outdated version of Report Server via the client application, it’ll give you this error message. “An […]

Leading zeroes in Power BI: Restoring them from auto-detection of data types

Leading zeroes in Power BI: Restoring them from auto-detection of data types

Power BI tries to be helpful and auto-detects data formats such as dates, decimal numbers and integers. However if you’re dealing with zip codes, employee IDs, product IDs, etc. that have leading zeroes, you may not want them auto-converted to integers/number format which removes the leading zeroes. Here’s how to get them back. From Power […]

How to add rows for dates between start and end dates in Power BI date range data

In Power BI there are several custom visuals available, such as Elastacloud’s Calendar Visual, that show the density of events over time. However, if your data includes date ranges (start date with a different end date, such as task/project lists), visuals like these will only understand one of the two dates (whichever you’ve chosen for the […]