SSAS ACE.OLEDB errors

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 …..

Read More

DAX modelling circular reference error

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 …..

Read More

Tableau vs Power BI

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 …..

Read More
Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog