Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add custom column to Usage Metrics

I am using the Usage Metrics dataset for my workspace.  I want to enrich the dataset with a day of week column or measure.  I am looking for usage trends by day (ie. Monday vs Friday etc.).   I can...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

Could you share more details about your specific requirement and post some sample data?

 

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-yuta-msft Jimmy, I would like to add a custom column or measure to the Power BI generated usage metrics dataset so that I can monitor usage by day of the week - Sunday, Monday, Tuesday etc.. How do I create this additional data with the date values available.  No sample data - all data is generated in the Power BI generated dataset.

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-yuta-msft  Jimmy, please let me know if it is possible to "enrich" the Poerw BI metrics dataset with custom columns and/or related tables... or simply write a measure that mimics a custom column

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Has this issue been resolved or does anybody have a solution? I have a use-case where I'd like to add a column to the user table indicating whether the person is a developer or a stakeholder. I have the data already in a local .xsls file but have not found any way to connect this to the report usage metrics in the Power Bi service. 

      • salikaziz's avatar
        salikaziz
        Frequent Visitor
        6 years ago

        hi, i am trying to do the same. Were you able to achieve this?