Power BI dataset

[spacedata]

I was hoping to use Power Query or Power BI to create a dataset and then connect to that dataset as itself as a datasource for other applications. Is this even posible?

[v-yuezhe-msft]

Hi @spacedata,

One option is to connect to Power BI dataset in Excel after installing Power BI publisher for Excel, and you can analyze that data in Excel using PivotTables and PivotCharts.

Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-publisher-for-excel/

Thanks,
Lydia Zhang

[Anonymous · Accepted solution]

Not really what Power BI is for.  If you really really have to, you could do that in excel.  If you need to spawn a dataset, Excel does offer a VBA engine.

Many superior ways to do this however, but Excel and VBA is often the quickest for a lot of people.

[spacedata]

I would like to create a dataset in Power BI or Power Query and then use that dataset as itsel a datasource to connect other applications to. Is this possible?