"Export" to internal table?

RMDNA · ‎03-02-2017

I have a dashboard that refreshes daily, and after every refresh, I want to take the data and append it to an internal table, in order to create a historical record.

Daily chart output:

02/05/17 US A B C

Append to internal table of:

02/03/17 US A B C

02/04/17 ...

etc.

At the moment, I have to manually export the chart into Excel, append the result into a master historicals table, and upload that table back into Power BI. This seems terribly inefficient. Can I dump data to an internal table?

Thanks as always.

Eric_Zhang · ‎03-06-2017

@RMDNA

At this moment, there's no way to retrieve data from a visual as "export data" does.

Is there any way you can access the source of the dashboard? I mean the backend database etc. If it is possible I think you can access the source and push data to a dataset via REST API.

Check Push data into a Power BI dataset.

Anonymous · ‎03-03-2017

Hi RMDNA

At the moment there is no native way to do that in Power BI Desktop.

But as you can integrate "R" in PBI Desktop, you can export your data!

@ImkeF has a blog article about this in english (as my article is in german...)

http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

Phil_Seamark · ‎03-03-2017

I've asked key people at MS on the PBI teams about this a number of times and it doesn't sound like it's coming soon. They suggest using Tabular Cubes in this scenario.

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!