Forum Discussion
vjnvinod
8 years agoImpactful Individual
Get data in Power BI
Hi , I am not able to find a way where Power BI "Get Data" has an option to extract the complete data from a pivoted excel. for instance, if i connect using Excel (which is Pivoted), power BI di...
v-lili6-msft
8 years agoCommunity Support
hi,@vjnvinod
when you create the Pivot Table, you need to choose Add this data to the Data Model,then you can import
the model into Power BI. otherwise it can't be imported.
Best Regards,
Lin
vjnvinod
8 years agoImpactful Individual