![]() There are a few possible reasons why your query is not returning any data in Power BI, even though it works in Oracle SQL Developer. (c.CASE_LEVEL_1 IN ('"redacted"', '"redacted"') OR (c.TICKET_OWNER_GROUP = '"redacted"' OR c.TICKET_OWNER_GROUP = '"redacted"' OR c.TICKET_OWNER_GROUP = '"redacted"')) ,c.ASSIGNED_TO_GROUP "Current Assigned to Group" ,cast(from_tz(cast(c.REFERRED_DATE_TIME as timestamp), 'UTC') at time zone 'US/Eastern' as date) "Referred DateTime" ![]() ,cast(from_tz(cast(C.CREATE_DATE as timestamp), 'UTC') at time zone 'US/Eastern' as date) "Create Date" Here is an example of the query with sensitive info replaced with "redacted" : So I believe the issue is with my query which PowerBI does not like for some reason. ![]() I tested another query that has worked in the past and it still works and returns data. There are no blank rows, just no data at all. When I use the same query to connect to the Oracle data source in PowerBI, it does the usual loading steps, but there is no data returned, only column headers. My query works as expected in Oracle SQL Developer.
0 Comments
Leave a Reply. |