Sunday, June 5, 2022
HomeBusiness IntelligenceExporting Energy BI Desktop Information Utilizing Energy BI Exporter

Exporting Energy BI Desktop Information Utilizing Energy BI Exporter


Exporting Power BI Desktop Data Using Power BI Exporter
Exporting Energy BI Desktop Information Utilizing Energy BI Exporter

I’m excited to announce that our wonderful crew at Information Vizioner has developed a light-weight and simple to make use of exterior device for Energy BI Desktop named Energy BI Exporter. The Energy BI Exporter is a free group device obtainable for obtain right here. With Exterior Instruments Basic Availability, you may anticipate to see increasingly Exterior Instruments constructed by our wonderful group members. I personally shocked to see many wonderful concepts flip into helpful instruments. Study extra about Energy BI bulletins about Exterior Instruments GA right here. I’m humbled to be named within the announcement although. So thanks to Microsoft for that.

Let me begin with just a little background. Previously few years, I wrote a sequence of weblog posts about exporting knowledge from Energy BI Desktop and Energy BI Service. These posts are fairly widespread. They’re within the prime 10 most visited posts on my web site, contributing to about 15% of my web site guests. Listed below are the earlier posts I wrote on this particular matter:

Other than my web site statistics exhibiting many individuals need to export knowledge from Energy BI Desktop, a few of my prospects requested the identical query. They wished to export the curated knowledge from their knowledge mannequin inside Energy BI Desktop to CSV format and make the curated knowledge obtainable for his or her different platforms. Whereas all of the strategies talked about in my earlier weblog posts are working, some customers nonetheless discover them complicated. So I believed, we will make it higher. We will make a simple device that exports the info with solely two clicks. So we began constructing the Energy BI Exporter as a micro-project. We added some extra concepts to the unique thought of solely exporting the info. We thought it’s good to export the info together with the desk names, column names and relationships. Having that info useful, we will rapidly construct the identical knowledge mannequin because the one we exported its knowledge however utilizing the CSV recordsdata as the info sources. The opposite thought was to pack every little thing in a ZIP file on the fly, so now we have a single ZIP file, together with the tables, columns, and relationships. In consequence, the primary model of the Energy BI Exporter is born. On this put up I clarify the way it works.

Downloading and Putting in Energy BI Exported

You possibly can obtain Energy BI Exporter from its official webpage from Information Vizioner web site. You require to enter your e-mail tackle then click on the Obtain button as proven within the following picture:

Downloading Power BI Exporter from Data Vizioner Website
Downloading Energy BI Exporter from Information Vizioner Web site

Relying in your browser, the obtain course of could also be barely completely different, however it downloads the power-bi-exporter.msi file.

You possibly can set up the file by double clicking it and following the directions throughout the installer.

Utilizing Energy BI Exporter

As talked about earlier, the concept of making the Energy BI Exporter was to have a devoted device that exports knowledge from Energy BI Desktop within the easiest doable method. After you efficiently put in the Energy BI Exporter, comply with these steps:

  1. Click on the Exterior Instruments tab after opening the Energy BI Desktop (both the Retailer model or the common downloaded model)
  2. Click on the Energy BI Exporter
Running Power BI Exporter from External Tools within Power BI Desktop
Operating Energy BI Exporter from Exterior Instruments inside Energy BI Desktop
  1. Navigate to the specified location to retailer the ZIP file
  2. Enter the File identify
  3. Click on the Save button
Select a Location to Store the Export Data
Choose a Location to Retailer the Export Information
  1. The Exporter begins exporting the info in a ZIP file within the location we chosen earlier. After the export course of is Performed, you may shut the Energy BI Exporter window
Power BI Exporter Successfully Exported the Data
Energy BI Exporter Efficiently Exported the Information

All accomplished!

Testing the Outcomes

Now you can navigate to the situation and open the ZIP file. The ZIP file should comprise all knowledge, tables, columns and relationships. The next picture exhibits the outcomes of exporting the info from my Energy BI knowledge mannequin:

Navigating the Exported Data from Power BI Desktop Using Power BI Exporter
Navigating the Exported Information from Energy BI Desktop Utilizing Energy BI Exporter

As you see within the above picture, the Energy BI Exporter efficiently exported 24 knowledge tables plus three schema recordsdata together with Tables, Columns and Relationships. Let’s take a look at my knowledge mannequin and see if all tables are exported. The next picture exhibits my knowledge mannequin:

Data Exported from Tables in Import Mode, DirectQuery Mode and Dual Mode
Information Exported from Tables in Import Mode, DirectQuery Mode and Twin Mode

Because the previous picture illustrates, my mannequin is a Composite Mannequin containing tables with completely different Storage Modes together with:

  • Import Information
  • DirectQuery
  • Twin

The mannequin even have some hidden tables and calculated tables. As you see, the Energy BI Exporter efficiently exported all tables.

Let’s open the Tables.csv file and see if the file contains all these tables. The next picture exhibits the contents of my Tables.csv file:

A List of Tables Exported from Power BI Desktop to CSV
A Checklist of Tables Exported from Energy BI Desktop to CSV

I go away it to you verify the remainder of recordsdata exported.

Getting the Updates

At any time when we launch a brand new model of the Energy BI Exporter, you’ll be notified by way of the device whenever you begin utilizing it. A notification message notifies you {that a} new model is out there to obtain. You possibly can merely click on the notification to obtain the brand new model.

Power BI Exporter Notification for New Releases
Energy BI Exporter Notification for a New Launch

Issues

Every bit of software program has some limitations, and Energy BI Exporter just isn’t an exception. Please hold the next factors in thoughts earlier than utilizing the Energy BI Exporter:

  • Energy BI Exporter won’t work if you’re linked to an occasion of Evaluation Companies (SSAS) or a Energy BI Dataset in Join Stay mode. If you’re not too certain what Join Stay means, I encourage you to have a look at this text
  • If there’s an error in your DAX expressions creating calculated columns or calculated tables, Energy BI Exporter will elevate an error message when it makes an attempt to export the info from the problematic desk
  • DAX errors in measures won’t have an effect on Energy BI Exporter
  • Energy BI Exporter exports the info of all tables throughout the knowledge mannequin. If the desk has not been loaded into the info mannequin, Energy BI Exporter can not entry it
  • Energy BI Exporter exports the tables obtainable within the knowledge mannequin no matter their underlying knowledge supply. In case your mannequin accommodates tables in DirectQuery mode linked to massive tables, then Energy BI Exporter nonetheless works. But it surely tries to export the entire knowledge from the info supply which can take a very long time if the underlying knowledge supply accommodates massive quantities of information

Conclusion

Energy BI Exporter is a device designed and applied with simplicity in thoughts. Exporting knowledge from Energy BI Desktop has by no means been as straightforward as it’s with Energy BI Exporter. Energy BI Exporter is a free device, however that doesn’t imply we won’t help it or replace it. So, as all the time, be at liberty to share your ideas and tell us what options you desire to us so as to add to the device. Hopefully, you discover the device useful.

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments