Forum Discussion

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
2 years ago
Solved

Using Excel and PowerBI from same source, how?

hi , i would like to use one source (either pbix or xlsx) as i need the data for both visualizing and using pivot tables, what is the best practice so i dont need to create two connections and calcul...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi bilingual ,

    Firstly I think you can import your data into Power BI Desktop.

    Then you can use the Power Query Editor to clean and transform your data as needed. This includes setting data types, creating calculated columns, or summarizing data. You can also use pivot column.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bilingual ,

Firstly I think you can import your data into Power BI Desktop.

Then you can use the Power Query Editor to clean and transform your data as needed. This includes setting data types, creating calculated columns, or summarizing data. You can also use pivot column.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.