Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
8 years ago

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...
Need Help
Show and Tell
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
8 years ago

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's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
8 years ago

v-lili6-msft

 

unfortunately the source of Pivot is SQL server, which i don't have acess to