Forum Discussion

GeroNikles's avatar
GeroNikles
Regular Visitor
1 year ago
Solved

Measures PowerBI

Hello, i am right now building a power BI Report by using data of a cube. Problem there is you cant "add" Data to it. That means it not possible to to calculations. So i imported the data into an...
Need Help
  • anmolmalviya05's avatar
    anmolmalviya05
    1 year ago

    Yes , You don't have to use excel, you can directly connect the data to power BI.
    If you want to apply any transformation then you can use in-built power query editor, and then for any type of calculation you can use DAX functions (250+ dax functions available) to create measures or calculated columns.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

     

    Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in



    GeroNikles

GeroNikles's avatar
GeroNikles
Regular Visitor
1 year ago

Yeah its possible to connect the cube to power BI, we have a few reports with that structure. Its an SQL Datasource.

So basically i dont ahve to do the extra step with the excel right?
anmolmalviya05 

  • anmolmalviya05's avatar
    anmolmalviya05
    Super User
    1 year ago

    Yes , You don't have to use excel, you can directly connect the data to power BI.
    If you want to apply any transformation then you can use in-built power query editor, and then for any type of calculation you can use DAX functions (250+ dax functions available) to create measures or calculated columns.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

     

    Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in



    GeroNikles