NOTE: This technique is not accessible (from 1st March 2019) as Microsoft discontinued supporting Net Designer in Azure portal. Microsoft is engaged on another resolution, however there isn’t a 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 the best way to import you at present present Energy BI Desktop fashions to SSAS Tabular 2016. Nevertheless, the tactic I defined is NOT supported by official Microsoft BI instruments like SSDT, so it’s possible you’ll take into account it as a WORKAROUND solely till Microsoft helps imploring Energy BI fashions in SSDT. On this publish, I present you the best way to import Energy BI Desktop Mannequin to SSAS Tabular 2017 utilizing Azure Evaluation Providers. It’s straightforward and trouble free.

• On this publish I do NOT clarify the best way to set up Azure Evaluation Providers
• This technique works just for SQL Server Evaluation Providers 2017 Tabular

As talked about earlier it’s very easy in evaluate with different strategies I defined in my earlier publish. Azure Evaluation Providers is able to importing Energy BI Desktop recordsdata making a Tabular mannequin model of your Energy BI mannequin within the cloud. Then you possibly can 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 information from WorldWideImportersDW from any desired mixture of reality tables and dimensions. I imported
• Create some easy Measures like:

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

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

• This opens a brand new web page for fabulous “Azure Evaluation Providers Net Designer”. You’re proper, an online designer for tabular fashions. How cool is that?
• Click on “Add” button underneath “Fashions” part
• Sure, you bought it, enter a reputation in 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 Providers. The following steps present you the best way to export Visible Studio mission file, open it in SSDT and deploy it to your on-premises occasion of SSAS Tabular 2017.

As you already seen, you possibly can write DAX queries, you possibly can 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 Venture” 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 Venture file
• Open SSDT
• Click on File –> Open –> Venture/Resolution and open the *.smproj file
• Choose “Built-in workspace” or “Workspace server” then click on OK

• From “Resolution 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 might (or might not) see a bunch of hidden Date dimensions that you simply haven’t created in Energy BI. These tables are mechanically created in Energy BI Desktop in case you tick “Auto Date/Time” possibility in Energy BI Desktop.

• You’ll be able to delete the date dimensions if you’d like
• From “Tabular Mannequin Explorer” broaden “Information Sources”
• Proper click on on the info supply then click on “Change Supply” to ensure your Tabular mannequin information supply is pointing to the appropriate server. If all the things’s proper then click on OK

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

• Below “Credentials” click on “Edit”

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

Be aware: Be sure your SSAS Tabular mannequin can entry the underlying information 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 possibly can deploy the mannequin to SSAS Tabular by clicking “Construct” menu and clicking “Deploy Resolution”

All carried out!

I simply need to convey 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 may well 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.