Try to replace these functions with Power Query transformations after importing the data. For example, FROM_TZ, CAST, and DBMS_LOB.SUBSTR are Oracle-specific functions. Here are some suggestions to troubleshoot the issue:Ĭheck if your query contains any date-related or Oracle-specific functions that might not be supported or might behave differently in Power BI. 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 kommentar(er)
