Category: SQL Server Analysis Services Tabular

AAS (Azure Analysis Services) / SSAS Tabular -Using BISM Normalizer to NOT Overwrite existing Partitions

I had partitions already configured and running on my AAS model. Partitions allow you to process only the data that needs to be updated. I have certainly done it in the past whereby mistake I updated all the partitions, which would mean I would then need to re-process them. This would not only take a lot of time (due to…

Using Azure Analysis Services to connect via an ODBC Source (Redshift)

I am busy working with a customer and had a challenge when using Azure Analysis Services to connect to Amazon Redshift via an ODBC connection. The first issue that I encountered was the following error: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; AWS PROD. This lead me…

Review of new Features coming to Power BI by Oct 2018 – From Business Applications Summit

I was fortunate to attend my first ever Business Applications Summit in Seattle. I had the pleasure of sharing an Airbnb with Matt Allington, Phil Seamark and Miguel Escobar, it was great to spend time with these Power BI Legends. I also did meet a lot of people and got to chat with people in the Microsoft Power BI team,…

BI-NSIGHT – Power BI (Community Blog Highlights – Power BI Germany – Latest Updates for Power BI Desktop – How Microsoft uses Power BI to run its Cloud Business – Connecting Datasets to Power BI Service) – SQL Saturday Brisbane (I’m presenting) – SQL Server (SQL Server 2017 – DAX Editor for SSDT – New Get Data Experience for SSDT)

I thought that this might be a quieter week, but once again there are a whole host of updates from Power BI updates, to SQL Server 2017 announcements. Quite a bit to read through so I hope you enjoy it. Power BI – Community Blog Highlights I actively participate in the Power BI Community, as well as when I feel…

BI-NSIGHT – Power BI (Publish in Web App, Enterprise Gateway GA, Desktop Update, Troux Content Pack, New Visuals) – SQL Server 2016 (CTP3.3, eBook, R)

So from last week to almost having nothing to talk about, to this week having a whole host of updates. Just to quickly mention I attended the first local Power BI User Group meeting in Brisbane this evening ( QLD Power BI User Group ), and it had a really great turnout, along with some great content for the first…

BI-NSIGHT – Power BI (Q&A for SSAS Tabular, Weekly Service Update, Lithium Content Pack, Mobile App for Windows 10 Mobile) – Azure (SQL Server Virtual Machines) – Power BI and Leveraging the Cloud

Even though I think a lot of people took time off over the Christmas period it seems that the Power BI team at Microsoft was full steam ahead. Which is a great thing to come back to work and have all these updates and new things to look into. Power BI – Q&A for SSAS Tabular The reason for me…

BI-NSIGHT – Power BI (IOS Power BI App for SSRS, Enterprise Gateway, Printing, AT Internet Content Pack) – SQL Server 2016 (eBook, Mobile Publisher)

The year is finally coming to a close and it has been a really busy but amazing year. I am looking forward to what will be happening in the Microsoft BI space next year, with the release of SQL Server 2016, as well as I have no doubt that there are a great things planned for Power BI. Power BI…

BI-NSIGHT – SQL Server 2016 (CTP 3.1, SSAS Tabular) – Power BI (Cortana, Mobile App, Enterprise Gateway, Bing Content Pack, API Updates, Sentiment Analysis) – Data Insights Summit – Power Apps

Once again this week there has been a lot of activity in the BI space. Which is great and is definitely keeping me on my toes! SQL Server 2016 – CTP 3.1 & SSAS Tabular This week Microsoft released a small update to SQL Server 2016, and one of the features that I am looking forward to testing is upgrading…

BI-NSIGHT – Power BI (Desktop Update, Service Updates, API Updates, Mobile App Update, Visual Contest Results, Content Pack – Stripe) – Office 2016 (Excel Updates, Power Query Update, Excel Predictions) – SQL Server Analysis Service 2012 Tabular Update – SQL Server Analysis Services 2016 Extended Events

So this week there was once again a whole host of updates with Power BI, as well as finally the official release of Office 2016. It sure is a busy time be in Business Intelligence space, especially in the Microsoft space. So let’s get into it… Power BI – Desktop Update So I woke up this morning to see that…

BI-NSIGHT – Power BI – (Pin to Dashboard, Extending Power BI Pro Trial, Mobile App Update, All About Dashboards, comScore Content Pack) – Cortana Analytics (Azure Data Catalog) – SQL Server 2016 (SQL Server Analysis Services (SSAS) Tabular Parallel Partition Processing) – Office 2016 (Official Release Date 22 Sep 2015) – Project Prajna

Once again there was a lot of updates from Microsoft, as well as some other really interesting information within the BI Space. So let’s get going! Power BI – Weekly Service Update (Pin to Dashboard, Extending Power BI Pro Trial) I have to say that they are rolling out service updates almost every week now. Which is great to see…