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