Notice: this article was initially used for closed beta-testing. It’s been edited for public use. The Power BI connector is now available in the official release available at the download page.
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.
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 columns in EasyMorph.
When a dataset is created, it can only be created with one table.
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.
we are trying to use the PowerBI API to do so, but it has been very challenging so far. Below the links that we have been using as a guide. I was hoping there would or might be a way to access data sets directly with EasyMorph. The connector shows data sets, and one of the sets is the usage metrics set. It would be immensly powerful for us if one could not only show datasets, but also access them with a connector.