Import Energy BI Desktop Mannequin to SSAS Tabular 2017 Utilizing Azure Evaluation Companies

NOTE: This technique is not obtainable (from 1st March 2019) as Microsoft discontinued supporting Net Designer in Azure portal. Microsoft is engaged on an alternate resolution, however there isn’t any timeframes or particulars to announce but. Learn extra right here. Within the meantime, you continue to can import your Energy BI Desktop Fashions to SSAS Tabular following the tactic described right here. 

Some time in the past I wrote a weblog put up on how one can import you at the moment current Energy BI Desktop fashions to SSAS Tabular 2016. Nonetheless, the tactic I defined is NOT supported by official Microsoft BI instruments like SSDT, so it’s possible you’ll think about it as a WORKAROUND solely till Microsoft helps imploring Energy BI fashions in SSDT. On this put up, I present you how one can import Energy BI Desktop Mannequin to SSAS Tabular 2017 utilizing Azure Evaluation Companies. It’s straightforward and problem free.

• On this put up I do NOT clarify how one can set up Azure Evaluation Companies
• This technique works just for SQL Server Evaluation Companies 2017 Tabular

As talked about earlier it’s very easy in evaluate with different strategies I defined in my earlier put up. Azure Evaluation Companies is able to importing Energy BI Desktop information making a Tabular mannequin model of your Energy BI mannequin within the cloud. Then you’ll be able to merely obtain Visible Studio mission file and redeploy it in your on-premises occasion of SSAS Tabular 2017. Let’s undergo the steps…

• Open Energy BI Desktop
• Import knowledge from WorldWideImportersDW from any desired mixture of reality tables and dimensions. I imported
• Create some easy Measures like:

Complete Gross sales = SUMX(‘Reality Sale’, ‘Reality Sale'[Unit Price] * ‘Reality Sale'[Quantity])

• Save your Energy BI Mannequin and shut the file
• Login to your Azure PortalBrowse to your occasion of Azure Evaluation Companies
• Click on on “Open” underneath “Net designer—preview”

• This opens a brand new web page for fabulous “Azure Evaluation Companies Net Designer”. You’re proper, an internet designer for tabular fashions. How cool is that?
• Click on “Add” button underneath “Fashions” part
• Sure, you bought it, enter a reputation on your mannequin and click on “Energy BI Desktop” button
• Click on “Browse” and choose the Energy BI file you saved earlier then click on “Import”

Now you efficiently imported your Energy BI Desktop mannequin to Azure Evaluation Companies. The following steps present you how one can export Visible Studio mission file, open it in SSDT and deploy it to your on-premises occasion of SSAS Tabular 2017.

As you already observed, you’ll be able to write DAX queries, you’ll be able to create new measures and so on…within the Net Designer. That is superior isn’t it?

• Click on “Open in” button
• Click on “Visible Studio Challenge” to obtain a ZIP file which incorporates Visible Studio mission

• Extract the ZIP file, you’ll see a “Mannequin.bim” and a *.smproj file which Visible Studio Challenge file
• Open SSDT
• Click on File –> Open –> Challenge/Answer and open the *.smproj file
• Choose “Built-in workspace” or “Workspace server” then click on OK

• From “Answer Explorer” proper click on the mission and click on “Properties”

• Modify the server by getting into your on-premises SSAS Tabular 2017 occasion then click on OK

• Double click on “Mannequin.bim” to open the mannequin
• You could (or could not) see a bunch of hidden Date dimensions that you just haven’t created in Energy BI. These tables are mechanically created in Energy BI Desktop when you tick “Auto Date/Time” possibility in Energy BI Desktop.

• You possibly can delete the date dimensions if you’d like
• From “Tabular Mannequin Explorer” broaden “Knowledge Sources”
• Proper click on on the info supply then click on “Change Supply” to verify your Tabular mannequin knowledge supply is pointing to the fitting server. If all the pieces’s proper then click on OK

• You could wish to test the “Impersonation” setting by proper clicking the info supply and click on “Edit Permissions”

• Underneath “Credentials” click on “Edit”

• Now you can choose “Impersonation Mode” from the drop down

Observe: Be certain that your SSAS Tabular mannequin can entry the underlying knowledge supply utilizing the impersonation mode you choose underneath the “Credentials” part. For example, my SSAS Service Account has db_datareader entry to WorldWideImportersDW database in SQL Server.

• Now you’ll be able to deploy the mannequin to SSAS Tabular by clicking “Construct” menu and clicking “Deploy Answer”

All accomplished!

I simply wish to carry your consideration to 2 hidden Date dimension which initially created by Energy BI Desktop mechanically with greater than 2 million rows. That is ridiculous, and in Energy BI it might probably value you an pointless massive PBIX file. So it’s greatest observe to disable “Auto Date/Time” in Energy BI Desktop from Energy BI Desktop Choices.