Forum Discussion
Impactful IndividualCan't import dataset into Excel
I'm trying to import a dataset as a pivot table into Excel.
However, in Excel, I only see one workspace and it is not the one I want....
Why is this happening?? The workspaces have exactly the same configuration and I'm the owner of both...
3 Replies
- collinq
Super User
HI webportal ,
To get data from a dataflow in Excel, you have to go to "Get Data - From Dataflow" (not "From Power BI" as you would for a "normal" workspace. After selecting From Dataflow you will have to sign in. select Continue and then the Dataflows will appear (under the Workspaces item) and the "normal" workspaces will NOT show.
- collinq
Hey webportal ,
Sorry, I misread that. To get a dataSET you need to have enabled connection experience as this article explains:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets
