The problem: While trying to import an excel file into an SSAS model, I kept getting the following error: Failed to save modifications to the server. Error returned: ‘The provider ‘Microsoft.ACE.OLEDB.12.0’ is not registered. The following system error occurred: Class …..
If you run powerBI in a VM, and you’re working with a large dataset, there are a couple of optimizations you may want to consider. The tabular database within PowerBI is an in memory database, and it can be computationally …..
Lately, in solving a simple problem, I’ve discovered something about powerBI that offers enormous potential. I found that the data model within powerBI is available as a tabular model in the cloud, leading to a visualized modelling environment that has …..
I’ve been working on a new power BI model this week, with the intent of showing historical attributes of work done over time. So I end up with table OrdersPFMHistory which contains a key that indicates a state at a …..
I’ve had the fortune in the last couple months to be doing a lot of innovative work for a client of mine using the power BI toolset. Recently, I’ve been busy publishing information with tableau, and have come to realize …..