Forum Discussion
Solved
Excel query PowerBI data model
Hi there,
While PowerBI is great, many of our end users are old school Excel lovers and want to weekly delivery of a dashboard in their inbox. What I am currently doing is:
- exporting a odc from web service
- creating a tabular pivot off that
- copying the pivot data and saving it as a csv
- importing that csv into another workbook via power query which contains my Excel dashboard
All of these steps seem super redundant and I am curious if there is a 'cleaner' way. Ideally I would like a prebuilt Excel dash that link with / replicate my powerbi data model. Is this possible?
I’m not sure if this is what you are after, but you can use power bi datasets as a source for excel:
2 Replies
I’m not sure if this is what you are after, but you can use power bi datasets as a source for excel:
This was exactly what I was after. Thanks so much Paul!!
