Forum Discussion
Power BI dataset
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?
- Anonymous9 years ago
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.
3 Replies
- spacedataNew Member
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?
- AnonymousNot applicable
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. - AnonymousNot applicable
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