A while ago I wrote a blog post on how to import you currently existing Power BI Desktop models to SSAS Tabular 2016. However, the method I explained is NOT supported by official Microsoft BI tools like SSDT, so you may consider it as a WORKAROUND only until Microsoft supports imploring Power BI models in SSDT. In this post, I show you how to import Power BI Desktop Model to SSAS Tabular 2017 using Azure Analysis Services. It is easy and hassle free.
- In this post I do NOT explain how to install Azure Analysis Services
- This method works only for SQL Server Analysis Services 2017 Tabular
How it works
As mentioned earlier it is really easy in compare with other methods I explained in my previous post. Azure Analysis Services is capable of importing Power BI Desktop files creating a Tabular model version of your Power BI model in the cloud. Then you can simply download Visual Studio project file and redeploy it in your on-premises instance of SSAS Tabular 2017. Let’s go through the steps…
- Open Power BI Desktop
- Import data from WorldWideImportersDW from any desired combination of fact tables and dimensions. I imported
- Create some simple Measures like:
Total Sales = SUMX(‘Fact Sale’, ‘Fact Sale'[Unit Price] * ‘Fact Sale'[Quantity])
- Save your Power BI Model and close the file
- Login to your Azure PortalBrowse to your instance of Azure Analysis Services
- Click on “Open” under “Web designer—preview”
- This opens a new page for fabulous “Azure Analysis Services Web Designer”. You’re right, a web designer for tabular models. How cool is that?
- Click “Add” button under “Models” section
- Yes, you got it, enter a name for your model and click “Power BI Desktop” button
- Click “Browse” and select the Power BI file you saved earlier then click “Import”
Continue reading Import Power BI Desktop Model to SSAS Tabular 2017 Using Azure Analysis Services
A while ago I wrote a blog post about Azure SQL Data Warehouse and Power BI which I explained how to install a new instance of Azure SQL Data Warehouse and how to visualise your Azure SQL DW data in Power BI. In this post I explain how to query an Azure SQL DW in SSMS and Visual Studio.
Querying Azure SQL Data Warehouse from Visual Studio
Prior the latest release of SQL Server Management Studio (SSMS) 2016, the only available tool for querying an Azure SQL Data Warehouse was SQL Server Data Tools (SSDT) for Visual Studio 2013 or 2015. Here is how you can use SSDT 2015 to query an Azure SQL Data Warehouse:
Continue reading Query Azure SQL Data Warehouse in SSMS and SSDT
In the previous post I announced that I will speak in “Visualising Your Azure SQL Data Warehouse with Power BI” webinar on 23 Jan 2016. The webinar host was Pass Business Intelligence Virtual Chapter. It was such an amazing experience for me to speak in the webinar and I would like to thank all 105 attendees. The attendees showed their enthusiasm by asking lots of questions during the webinar.
In this webinar I demonstrated:
- How to install Azure SQL DW in Azure Portal
- How to configure firewall settings from Azure Portal and SQL Server Management Studio (SSMS) 2016
- How to connect directly from Azure SQL DW to Power BI Service and the other way around
- How to visualise you Azure SQL DW data warehouse data with Power BI Desktop (both Data Import and DirectQuery scenarios)
- Comparing the features of different scenarios that helps you finding the best for your use cases
and much more…
You can see and download the session materials as follows.
Watch Visualising Your Azure SQL Data Warehouse with Power BI on YouTube
Continue reading Webinar Materials: Visualising Azure SQL DW with Power BI
It’s such an honor that I’m invited to speak in Pass Business Intelligence Virtual Chapter webinar which will be held on 23 Jan 2016. I would be very happy to have you all in the webinar.
You can register here.
You can register and subscribe for Pass upcoming events here.
- Introduction to Power BI
- Introduction to Azure SQL Data Warehouse
- Azure SQL Data Warehouse Installation/Configuration
- Connecting Directly from Azure SQL Data Warehouse to Power BI Service
- Creating Simple Reports on Power BI Service
- Visualising Azure SQL Data Warehouse Using Power BI Desktop
Continue reading Webinar: Visualising Your Azure SQL Data Warehouse with Power BI
Without a doubt cloud computing is going to change the future of data analytics and data visualisation very significantly. Microsoft Azure SQL Data Warehouse recently released for public preview. Combining Power BI as a powerful data visualisation tool with Azure SQL Data Warehouse will give the users the ability to see data insights of their data stored in Azure Data Warehouse very easily. In this post I explain how to install Azure SQL Data Warehouse and the the way it works with Power BI. Before going any further I’d like to have a look at the Azure SQL Data Warehouse very briefly.
What Is Azure SQL Data Warehouse?
Based on Microsoft documentation a SQL Data Warehouse is
“Azure SQL Data Warehouse is an enterprise-class distributed database capable of processing petabyte volumes of relational and non-relational data.”
Azure SQL Data Warehouse supports stored procedures, user-defined functions, indexes and collations. It uses columnstore index technology which significantly improves query performance as well as getting you up to 5 times compression in compare with traditional row based indexing.
I leave it to you learn more about Azure SQL Data Warehouse. But, it is important to keep in mind that there are some features like primary keys and foreign keys that are NOT supported in Azure SQL Data Warehouse which affect the way we use Power BI as a data visualisation tool over Azure SQL Data Warehouse. Without primary keys and foreign keys there is no physical relationships between the tables so Power BI service cannot detect any relationships by itself. There is a workaround for this that we can create some SQL views in Azure side to make it work. This can be an expensive solution. The other way is to load the data warehouse into a Power BI Desktop model which can detect the relationships automatically.
Now you know a bit bout Azure SQL Data Warehouse let’s get back to the subject and talk more about Power BI and Azure SQL Data Warehouse.
First things first. You need to have a Microsoft Azure subscription. If you don’t already have it you can use it for a one month trial here. You’ll also get $250 credit. But, remember that if you succeed the $250 in less than a month then you’ll need to pay for it if you want to use it longer.
Install Azure SQL Data Warehouse
After you get your Azure subscription, login to your account and you should see a dashboard like this
I’m not going to explain the above dashboard as it is out of scope of this article.
Continue reading Azure SQL Data Warehouse and Power BI