# Power BI connector / actions **URL:** \ **Category:** General Q&A\ **Created:** [December 24, 2019, 2:26pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510 "2019-12-24T14:26:06Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [December 24, 2019, 2:26pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/1 "2019-12-24T14:26:07Z")
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](https://easymorph.com/download.html). ## 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](https://community.easymorph.com/uploads/default/original/2X/6/6926aaf46625d59a492cd7315f750c98f8ed2ada.png) ## 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. ![image](https://community.easymorph.com/uploads/default/original/2X/6/6f9a2063c8e26ae5bd416c29bde46ac60b6ea025.png) ## 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](https://community.easymorph.com/uploads/default/original/2X/4/4c5aa38ad59188a0f238b2705977506bbf24f579.png) Please report anything confusing, bugs, problems with Power BI in this topic. Feature suggestions are welcome too. Thanks! ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [December 30, 2019, 1:11pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/2 "2019-12-30T13:11:44Z")
Any feedback, anyone? 🙂 ---
**Author:** ![adambeltz](https://community.easymorph.com/user_avatar/community.easymorph.com/adambeltz/32/3678_2.png) [@adambeltz](https://community.easymorph.com/u/adambeltz)\ **Post date:** [January 3, 2020, 9:02pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/3 "2020-01-03T21:02:52Z")
Hey @dgudkov - I'm starting to test now. Sorry crazy couple weeks. ---
**Author:** ![adambeltz](https://community.easymorph.com/user_avatar/community.easymorph.com/adambeltz/32/3678_2.png) [@adambeltz](https://community.easymorph.com/u/adambeltz)\ **Post date:** [January 3, 2020, 9:36pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/4 "2020-01-03T21:36:40Z")
Emailed you directly on some of the credential things. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [January 3, 2020, 10:07pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/5 "2020-01-03T22:07:11Z")
Thanks @adambeltz! ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [January 6, 2020, 11:34pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/6 "2020-01-06T23:34:21Z")
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. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [January 7, 2020, 3:45pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/7 "2020-01-07T15:45:06Z")
A post was split to a new topic: [Error: PowerBI API Error: Failed to process dataset PostDataset](https://community.easymorph.com/t/error-powerbi-api-error-failed-to-process-dataset-postdataset/1545) ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [January 7, 2020, 10:27pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/8 "2020-01-07T22:27:10Z")
A post was split to a new topic: [Feature request for Power BI: search field in the Pick dialog](https://community.easymorph.com/t/feature-request-for-power-bi-search-field-in-the-pick-dialog/1548) ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [January 7, 2020, 10:19pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/9 "2020-01-07T22:19:06Z")
A post was split to a new topic: [Failed to delete a Power BI dataset](https://community.easymorph.com/t/failed-to-delete-a-power-bi-dataset/1547) ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [March 13, 2020, 8:09pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/10 "2020-03-13T20:09:23Z")
\*\*\*\* moved to #General Q&A ---
**Author:** ![RJO](https://community.easymorph.com/user_avatar/community.easymorph.com/rjo/32/4084_2.png) [@RJO](https://community.easymorph.com/u/RJO)\ **Post date:** [March 25, 2020, 10:53am UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/11 "2020-03-25T10:53:37Z")
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. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [March 25, 2020, 11:09am UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/12 "2020-03-25T11:09:58Z")
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. ---
**Author:** ![RJO](https://community.easymorph.com/user_avatar/community.easymorph.com/rjo/32/4084_2.png) [@RJO](https://community.easymorph.com/u/RJO)\ **Post date:** [March 25, 2020, 11:30am UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/13 "2020-03-25T11:30:09Z")
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. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [June 27, 2022, 8:54pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/14 "2022-06-27T20:54:49Z")
A post was split to a new topic: [Power BI - Create table if it doesn’t exist](https://community.easymorph.com/t/power-bi-create-table-if-it-doesn-t-exist/3736) ---
**Author:** ![Albert\_Fabritius](https://community.easymorph.com/user_avatar/community.easymorph.com/albert_fabritius/32/2104_2.png) [@Albert\_Fabritius](https://community.easymorph.com/u/Albert_Fabritius)\ **Post date:** [December 22, 2022, 8:23pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/15 "2022-12-22T20:23:14Z")
Is there a possibility to use the connector to download data or data sets from PowerBI? Specifically, the usage metrics, which is a standard set of data PowerBI offers. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [December 22, 2022, 11:00pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/16 "2022-12-22T23:00:09Z")
That sounds like metadata rather than data. As far as I know, it's not possible to pull out _data_ out of Power BI. Do you happen to have a link to the documentation about such usage metrics? ---
**Author:** ![Albert\_Fabritius](https://community.easymorph.com/user_avatar/community.easymorph.com/albert_fabritius/32/2104_2.png) [@Albert\_Fabritius](https://community.easymorph.com/u/Albert_Fabritius)\ **Post date:** [December 23, 2022, 12:30pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/17 "2022-12-23T12:30:02Z")
Hi Dmitry, 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. > **[How to Call Power BI REST APIs with Custom Connector and Postman](https://skypoint.ai/blog/power-bi-rest-apis/)** > > Skypoint is a HITRUST r2 certified data unification and agentic AI platform that accelerates productivity and efficiency for healthcare organizations. > **[How to access Power BI REST APIs programmatically](https://www.sqlshack.com/how-to-access-power-bi-rest-apis-programmatically/)** > > This article explains how to use the Power BI REST API programmatically. > **[Monitor Usage Metrics in Power BI Workspaces (preview) - Power BI](https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics)** > > Learn how to view, save, and analyze usage metrics for Power BI reports in workspaces. Track report views, viewers, performance, and user engagement to optimize your content strategy. ---
**Author:** ![Cambridge](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/a183cd/32.png) [@Cambridge](https://community.easymorph.com/u/Cambridge)\ **Post date:** [August 11, 2023, 9:20am UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/18 "2023-08-11T09:20:46Z")
> [@dgudkov](#): > > When a dataset is created, it can only be created with one table. Hi dgudkov, Is it still the case - it can only be create with one table? I success to create a dataset with one table, and failed to export to create another table in the same dataset. Thanks. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [August 12, 2023, 2:41am UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/19 "2023-08-12T02:41:31Z")
Yes, it's still the case. EasyMorph doesn't create another table in an existing dataset automatically. I would suggest trying to create a new table in the dataset manually via Power BI Service (online). Although, I'm not sure if Power BI Service provides this capability. ---
**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\ **Post date:** [August 17, 2023, 9:08pm UTC](https://community.easymorph.com/t/power-bi-connector-actions/1510/20 "2023-08-17T21:08:28Z")
A post was split to a new topic: [Incomplete and failed export to Power BI](https://community.easymorph.com/t/incomplete-and-failed-export-to-power-bi/4740)