About EasyMorph Tutorials & Examples Web-help

Power BI connector / actions

The Power BI connector / actions are now available for closed beta-testing.

The installer can be downloaded here: https://easymorph.com/download/EasyMorph.Setup410pbi.zip.

The installed version is identical to production v4.1 with the only addition of the “Power BI” connector, and actions “Export to Power BI” and “Power BI command”. It can be safely rolled over existing installations of v4.1 without any side effects.

Note that it’s NOT a beta of v4.2. For the purpose of testing only the Power BI connector/actions we’ve made a special build based on v4.1. However, the Power BI connector/actions will be officially released in v4.2 in mid-January.

Here is what to test:

Power BI connector

The both Power BI actions in EasyMorph (Export and Command) require a configured and authorized “Power BI” connector. You will need to use a Power BI account to authorize a connector.

Feel free to use the default EasyMorph application, if you haven’t created your organization’s own Power BI app.

image

Action “Export to Power BI”

The action exports data from EasyMorph into an existing, or new Power BI push-dataset. Under the hood exporting is done by batches of 10K rows. Large datasets can take a few minutes to export. Before exporting, all values in EasyMorph data are automatically validated for possible type mismatching with Power BI data types. Type auto-detection can identify appropriate Power BI data types for exported column in EasyMorph.

When a dataset is created, it can only be created with one table.

Action “Power BI Command”

This action can perform 3 commands:

  • List of available datasets + dataset attributes
  • Delete rows in a dataset table
  • Refresh dataset (only makes sense for non-push datasets)

image

Please report anything confusing, bugs, problems with Power BI in this topic. Feature suggestions are welcome too.

Thanks!

Any feedback, anyone? :slight_smile:

Hey @dgudkov - I’m starting to test now. Sorry crazy couple weeks.

Emailed you directly on some of the credential things.

Thanks @adambeltz!

Feel free to use the EasyMorph OAuth application (selected by default) in the PowerBI connector. Your published datasets won’t be shared with us or anyone else.

A post was split to a new topic: Error: PowerBI API Error: Failed to process dataset PostDataset

A post was split to a new topic: Feature request for Power BI: search field in the Pick dialog

A post was split to a new topic: Failed to delete a Power BI dataset

**** moved to #uncategorized

Unfortunately here in Natixis it does not work and no logs can explain it, only “an error occurred”. It had barely chance to work with mandatory proxy authentication and the identity federation we use here.

Does publishing datasets work from Power BI Desktop installed on the same machine and run under the same user account as EasyMorph? If yes, can you please send a screenshot of connection settings in Power BI Desktop to our support.

There is no “connection settings” i’m aware of. In Power BI Desktop you just have to “sign in” entering your email and there it goes. There’s a kind of popup appearing with nothing inside, identity federation is doing its job in a transparent way, then you are connected. So yes, publishing works here.

If you know somewhere where I can get Power BI cloud connection information, I can have a look.

To learn more about EasyMorph visit easymorph.com.