Forum Discussion
Import Data model in Excel
Super Userand cubemember formulasTry to limit that. Power BI is based on SSAS Tabular and needs to convert the DAX to MDX for that which results in performance penalties. Better to use DAX directly.
What you can try is import individual tables from your Power BI dataset and then wire them up in the Power Pivot data model. That way you have the data model and the users can refresh individual tables. (of course that requires your dataset to be rather small).
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
You use Analysis Services in import mode.