# Import Power BI Dataset \[DONE\]

**URL:** <https://community.easymorph.com/t/import-power-bi-dataset-done/4314>\
**Category:** Feature requests\
**Created:** [February 24, 2023, 3:40pm UTC](https://community.easymorph.com/t/import-power-bi-dataset-done/4314 "2023-02-24T15:40:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**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:** [February 24, 2023, 3:40pm UTC](https://community.easymorph.com/t/import-power-bi-dataset-done/4314/1 "2023-02-24T15:40:22Z")

</div>

Good afternoon -  
one feature that seems to be fairly elusive is the ability to retrieve the powerbi dataset as a data source to projects. I was curious if this is a feature that has been discussed before?

Power BI has the "Analze In Excel" which treats it like like a pivot table so not really good for data mashing and I also saw this post on connecting to the dataset via Azure Data Factory (ADF) that seemed logical

[Copy Data from Power BI through Azure Data Factory / Synapse Pipeline via Managed Identity Authentication– Part 4 – DataSharkX (wordpress.com)](https://datasharkx.wordpress.com/2022/11/03/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-via-managed-identity-authentication-part-4/)

---

<div class="post-metadata">

**Author:** ![bolud](https://community.easymorph.com/letter_avatar_proxy/v4/letter/b/82dd89/32.png) [@bolud](https://community.easymorph.com/u/bolud)\
**Post date:** [March 6, 2023, 4:41am UTC](https://community.easymorph.com/t/import-power-bi-dataset-done/4314/2 "2023-03-06T04:41:28Z")

</div>

Couple of years ago I have retrieved dataset from Power BI report using database stored procedure. What I did was convert the dataset into JSON and pass as a parameter in database stored procedure. Stored procedure will parse the JSON and store it in table. Then that data can be used directly from easyMorph. Each time when dataset gets refreshed it will call stored procedure and update the table.

---

<div class="post-metadata">

**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 22, 2023, 6:40pm UTC](https://community.easymorph.com/t/import-power-bi-dataset-done/4314/3 "2023-08-22T18:40:03Z")

</div>

It's an interesting idea because Excel somehow can pull data from a Power BI dataset. But so far I haven't seen any official API for accessing data in Power BI datasets. I just ran a few internet searches again but no luck.

If you ever happen to run into an announcement of such an API, let us know.

---

<div class="post-metadata">

**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:** [July 22, 2024, 5:34pm UTC](https://community.easymorph.com/t/import-power-bi-dataset-done/4314/4 "2024-07-22T17:34:31Z")

</div>

Added in v5.8.

 ![image](https://community.easymorph.com/uploads/default/original/2X/c/c415f4b2fedc86204cab5f60365ed3b82f1190a8.png)

---

<div class="post-metadata">

**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:** [February 5, 2025, 2:12am UTC](https://community.easymorph.com/t/import-power-bi-dataset-done/4314/5 "2025-02-05T02:12:15Z")

</div>

Split this topic on February 5, 2025, 2:12am UTC

3 posts were split to a new topic: [Import from SSAS using custom DAX query](https://community.easymorph.com/t/import-from-ssas-using-custom-dax-query/5973)
