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

v-lili6-msft

 

thanks for this, but not sure what you are trying to achieve, can you please show me the steps?

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