Need to edit variables in dataset from power bi service

[Anonymous]

Hello all!

I have a data set in the power bi service (it is a power bi data set, not excel or anything like that) that i am trying to build a report off of in the desktop app. The problem is that i cant edit/format the variables, like making a date hierarchical. The data set needs to remain a power bi data set as the plan is to automate its refresh. Any ideas how i can edit these variables?

[amitchandak]

@Anonymous , there is no data model access as of now. So I doubt you can

[parry2k]

@Anonymous in case of live connection (in this case), you cannot make changes to the model. Any addition/change you need, you need to do in the source dataset (published dataset). 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

So since the source publishing to power bi has this variable as a date, but doesn't have an option to make hierarchical, as i would imagine most sources wouldn't, it is impossible for me to make it hierarchical for now?

[parry2k]

@Anonymous first thing first,  you need to use the proper name, it is not a variable, it is a column, the variable has a very different meaning. 

Now to your question, you have to create hierarchy int he model (published dataset), you cannot make changes to the model if you are doing a live connection.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Im following, for future reference what would be the difference then between a column and a variable?

[parry2k · Accepted solution]

@Anonymous set of columns are part of a table, for example, you have a customer table and it has three columns, cutomer name, cutomer address, customer city, these all are columns and variable is someting user in DAX expression, for example

Test Measure = 
VAR __x = SUM ( Table[Profit] )
VAR __y = SUM ( Table[Growth] )
RETURN 
__x + __y

In the above expression __x and __y are variables. I hope it helps.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Thank you for the explanation, i come from an analyst background and am doing analyst work, where columns hold variables. Ill be sure to note the change in meaning in regards to power bi in the future!