Forum Discussion
Import Data model in Excel
Hello all, I am working on a project where I have created a data model in powerBI and have it saved in a dataset. I have brought this into excel through a connection, and I have various pivot tab...
Thank you. How do you bring in the data set into excel though? When I go into Excel and click Get Data, I only see options for PowerBi, DataFlows, and Dataverse.
PowerBi only gets me a connection.
Data flows is a layer to low, because I assign security at the dataset. My data set uses a data flow, but then security is not applied.
I am not familiar with Data Verse.
Maybe its something with my settings? Just want to confirm you can bring in your dataset some how besides those three options I see (or if Dataverse, how do I use that)?
Thank you
lbendlin
Super User
Super UserYou use Analysis Services in import mode.