Forum Discussion

Acarrier's avatar
Acarrier
Frequent Visitor
5 years ago
Solved

PowerBi summarizes Oracle query (view) data incorrectly by date

Hi All,    Some data in a power Bi report is an oracle view about numbers for a work shift. Each day has 2 shifts, 1 and 2. Basically the Key is the prod_date and prod_sh. See the query below retur...
Need Help
  • Acarrier's avatar
    Acarrier
    5 years ago

    Hello Evelyn,

     

    THanks again for your input, it is appreciated. 

    The object in question is a view, a union of other tables/joins. 

    I just solve my issue. I ended up using a pipelined function. In oracle a pipelined function is a function that acts like a table. You can make a view off of a pipelined function. This is what I did. Somehow this solved the issue. I cannot explain how this solved it and why the original view was a problem. I tried many thinks. My view was a summary. I tried a view that was all the detail rows. The same fields were wrong as well. 

     

    I am at a loss, but I found a reasonable workaround. 

     

    Thanks!

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Acarrier ,

 

To my knowledge, values will not be automatically summed based on any columns in Power Query.

 

So It seems that advanced query is added in Advanced options when connect to database or you have applied some transformations( such as Groupby Date) to the table in Power Query.

 

Please check them.

 

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

Acarrier's avatar
Acarrier
Frequent Visitor
5 years ago

Hello Evelyn, 

 

THanks for your reply. 

I have verified the parameters. They are ok. See the screenshots below.

- I tried a new oracle view that includes a key field (varchar) and I specified that that is the key field in the model area. 

- Checked in power query for additional steps. 

- Traced the oracle connection. The query sent to oracle is not grouped by.

 

When I reload in PowerBI I get for example 1007 rows fetched, which is the count you get AFTER summarization by date. 

 

I do not understand where this summarization is done! Perhaps a driver issue somewhere???

 

I think my next step is to load the detail rows and have powerbi Summarise per day and shift. I am at a loss to understand.

 

Thank you again!