Import Power BI Dataset [DONE]

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)

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.

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.

Added in v5.8.

image

1 Like

Hi,

Is it working on live connection dataset ? I mean can you import a Power BI dataset with a SSAS cube as datasource ? Because this would be a way for Easymorph to query a SSAS cube, using Power BI technology.

But if you are able to send DAX query to Power BI, I guess you would be able to do the same to SSAS tabular model cubes ? In companies, SSAS cubes can be a way to expose data, a bit like Business Objects universes. So it's nice if Easymorph can manipulate that.

To be honest, I don't know, we didn't try that.

Technically, sending a query to SSAS isn't hard. Making the Visual Query Editor work with SSAS is more challenging. Would sending a custom DAX query to SSAS work for you, or do you need SSAS supported in the Visual Query Builder?