Query data from Power BI

[ajhunt1]

Hi,

When I query data from a Power BI dashboard, it only puts that data into a pivot table. Is there any way to get it into a query editor so that I can edit the data and merge it with other queries, or do I have to query the original source of the information?

Thanks,
Andrew

 

[Ken Puls]

This is something I've wanted for a long time. The two options that I generally run with:
1) Separate the queries from the PBIX file and do them in Dataflows instead. Then you can connect PBIX files to them to build new reports, or you can connect Excel files to it to injest and enrich the data. Note that this does require a Pro License as it has to be done in a named Workspace (not My Workspace.)
2) Create a Pivot against the the Power BI dataset, pull everything on to the PivotTable, set it in tabular form with repeating labels and... pull it into Power Query to "re-build" your model.

#2 isn't awesome, but it does work. It's actually an essential part of one of my solutions as Power BI has a connector I need that Excel doesn't have today.