Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

ferzfeld

PBI RS January 2019 - Power Query Editor "Group By" Fails on Oracle Source

Submitted by Advocate II on ‎01-29-2019 02:07 AM

Hello all,

 

with the new January 2019 release it is not possible to apply the "Group by" step to your Oracle data source anymore (see screenshots). Problem can be reproduced on different servers, databases, tables and computers.

 

This is a massive show stopper for us as we have many users using Oracle as a source in Power BI.

 

Can you please look into this issue? Thank you! 🙂

 

Select Group by on a column in PQESelect Group by on a column in PQEClick OKClick OKAlways receive this error, tested it on different servers and databasesAlways receive this error, tested it on different servers and databases

Status: New
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎01-29-2019 05:15 AM

Hi ferzfeld, have you tested your query on SQL developer? The error shown is not PowerBI but Oracle and happens when an aggregate measure is used with no GROUP BY clause.

ferzfeld
Advocate II
Advocate II
‎01-29-2019 05:31 AM

Hi 7700,

 

Thank you for your reply.

 

  • No query is used, the following steps have been taken for this example:
    • Get Data -> Oracle Source
    • Select the Plant-Dimension table from the oracle schema
    • Edit --> Power Query Editor
    • Right click on the column, select "Group By", click OK
    • Generated SQL Statement by PQE sent to Oracle DB is faulty and causes Error
  • The exact SAME steps performed on the August 2018 PBI RS Desktop will work just fine

 

Luckily - reports that are created with the August 2018 release and published to the January 2019 Report Server will still refresh. The bug lies in Power BI Desktop January 2019. 

 

Actually we have Microsoft consultants in our enterprise at the moment and they were able to reproduce this issue as well.

 

By the way - the same steps on a Microsoft SQL Server work fine, only Oracle DB connection seems to have this problem.

 

Looking forward from a feedback from Microsoft about this 🙂

NormRidg
New Member
‎03-19-2019 08:59 AM

We are getting the exact the same error.  Does not  ocurr with Microsoft SQL server databases.  Just the Oracle ones.  I expect Power Query to correctly construct the query for Oracle if Power BI is to be an overall data visualization tool.   Error occurrs even when picking just one field to group and requesting a row count.  

 

Also have a Power Query built before December for an Oracle data table using a Grouped By and it stlll works.  Duplicated the table today and tried a very simple Grouped By and it now fails.

MattG
Advocate II
Advocate II
‎08-20-2019 06:26 AM

Hi 

 

I've just come accross this issue and wanted to see if it had been resolved or accepted as an issue?

 

Matt

ferzfeld
Advocate II
Advocate II
‎08-26-2019 03:20 AM

Hi @MattG ,

from what I have heard from the users it has been resolved with the latest Desktop release they are using!

Thanks for asking 🙂

Idea Statuses