Forum Discussion

AdamBoltryk's avatar
AdamBoltryk
Resolver I
7 years ago

Using measures/data in different report.

Hi All, I am looking for someone who colud show me direction or say simple 'it's impossible' :)   What I have: 1. I have source data (hrs, ppl etc - transaction level) for company A, B and C (sam...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi AdamBoltryk ,

  1. At least in theory, if the report contain the data of KPIs, you can use it. However, I don’t know what the actual table structure and the relationship is. Maybe you can post some sample data.
  2. As you know, we have to load the entire table while getting data. But you can transform the data to keep the rows what you want in Power Query after loading it.
  3. Certainly, we can’t save data from report into the files. I’m afraid you have to save it manually.

 

Best Regards,

Xue Ding

 

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

  • AdamBoltryk's avatar
    AdamBoltryk
    Resolver I
    7 years ago

    Thank you for answer.

    Actual tables structure and relations is a bit complicated.

    And it's only 1st Group Data model from my example (company A, B and C). So prepare 'sample data' could be a bit difficult :)

    I know rows/columns delete mechanism. And I am using it if neccersary. thx.

    And looks I have to stay with my manual process.

    Thank you.