NOTE: This methodology is not obtainable (from 1st March 2019) as Microsoft discontinued supporting Internet 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 publish on how you can import you presently 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 chances are you’ll contemplate it as a WORKAROUND solely till Microsoft helps imploring Energy BI fashions in SSDT. On this publish, I present you how you can import Energy BI Desktop Mannequin to SSAS Tabular 2017 utilizing Azure Evaluation Companies. It’s simple and trouble free.
- On this publish I do NOT clarify how you can set up Azure Evaluation Companies
- This methodology 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 publish. Azure Evaluation Companies is able to importing Energy BI Desktop recordsdata making a Tabular mannequin model of your Energy BI mannequin within the cloud. Then you may merely obtain Visible Studio venture file and redeploy it in your on-premises occasion of SSAS Tabular 2017. Let’s undergo the steps…
- Open Energy BI Desktop
- Import information 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” beneath “Internet designer—preview”
- This opens a brand new web page for fabulous “Azure Evaluation Companies Internet Designer”. You’re proper, an online designer for tabular fashions. How cool is that?
- Click on “Add” button beneath “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 you can export Visible Studio venture file, open it in SSDT and deploy it to your on-premises occasion of SSAS Tabular 2017.
As you already seen, you may write DAX queries, you may create new measures and many others…within the Internet 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 venture
- 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 venture and click on “Properties”
- Modify the server by coming into your on-premises SSAS Tabular 2017 occasion then click on OK
- Double click on “Mannequin.bim” to open the mannequin
- You might (or might not) see a bunch of hidden Date dimensions that you simply haven’t created in Energy BI. These tables are robotically 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 would like
- From “Tabular Mannequin Explorer” broaden “Knowledge Sources”
- Proper click on on the information supply then click on “Change Supply” to verify your Tabular mannequin information supply is pointing to the suitable server. If every little thing’s proper then click on OK
- You might need to examine the “Impersonation” setting by proper clicking the information supply and click on “Edit Permissions”
- Below “Credentials” click on “Edit”
- Now you can choose “Impersonation Mode” from the drop down
Notice: Be certain that your SSAS Tabular mannequin can entry the underlying information supply utilizing the impersonation mode you choose beneath the “Credentials” part. For example, my SSAS Service Account has db_datareader entry to WorldWideImportersDW database in SQL Server.
- Now you may deploy the mannequin to SSAS Tabular by clicking “Construct” menu and clicking “Deploy Answer”
All finished!
I simply need to convey your consideration to 2 hidden Date dimension which initially created by Energy BI Desktop robotically with greater than 2 million rows. That is ridiculous, and in Energy BI it may price you an pointless massive PBIX file. So it’s greatest follow to disable “Auto Date/Time” in Energy BI Desktop from Energy BI Desktop Choices.
