Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Syndicate_Admin
Administrator
Administrator

Oracle: ORA-00911 PowerBI Native Query SQL

Hola intento hacer una consulta nativa en SQL en Pbi pero tengo un problema, en SQL Dev la consulta está bien . No entiendo por qué ...


escoger
MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_DATE_KEY,
OPERATIONAL_PRODUCT. código
OPERATIONAL_PRODUCT.NAME_FR,
DISTRIBUTION_ROUND. ROUND_NAME,
OPERATIONAL_PRODUCT. APP_SOURCE,
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. EXACT_SUFFIX) como "EXACT_SUFFIX",
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. VENTILATED_PP) como "VENTILATED_PP" ,
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. VENTILATED_STREET) como "VENTILATED_STREET",
sum( MRA_DM.FACT_GEO_ROUND_VOLUME. VENTILATED_AREA) como "VENTILATED_AREA",
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_CODE,
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_NAME,
MAILBOX_MRA. ROUND_NAME como ROUND_NAME_MAILBOX

De

MRA_DM.DIM_OPERATIONAL_PRODUCT OPERATIONAL_PRODUCT,
MRA_DM.DIM_DISTRIBUTION_ROUND DISTRIBUTION_ROUND,
MRA_DM.FACT_GEO_ROUND_VOLUME,
MRA_DM.DIM_MAIL_ACTIVITY_CENTER MAIL_ACTIVITY_CENTER,
MRA_DM.DIM_MAILBOX_MRA MAILBOX_MRA
Dónde
(DISTRIBUTION_ROUND. DISTRIBUTION_ROUND_KEY=MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_ROUND_KEY)
y (MAIL_ACTIVITY_CENTER. MAIL_ACTIVITY_CENTER_KEY=MRA_DM.FACT_GEO_ROUND_VOLUME. MAIL_ACTIVITY_CENTER_KEY)
y ( MRA_DM.FACT_GEO_ROUND_VOLUME. MAILBOX_KEY=MAILBOX_MRA. MAILBOX_KEY)
y ( MRA_DM.FACT_GEO_ROUND_VOLUME. OPERATIONAL_PRODUCT_KEY=OPERATIONAL_PRODUCT. OPERATIONAL_PRODUCT_KEY)
y
(
OPERATIONAL_PRODUCT. código en ( 'GF MANU','GF','GF MECA','GF MECA PRIOR','GF MANU PRIOR','CBUNDLE de GF','GF RS','ABO LBL','NF MANU','NF','NF MECA','NF MECA PRIOR','NF MANU PRIOR' )
)

y MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_DATE_KEY = '20210301'
grupo por

MRA_DM.FACT_GEO_ROUND_VOLUME. DISTRIBUTION_DATE_KEY,
OPERATIONAL_PRODUCT. código
OPERATIONAL_PRODUCT.NAME_FR,
DISTRIBUTION_ROUND. ROUND_NAME,
OPERATIONAL_PRODUCT. APP_SOURCE,
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_CODE,
MAIL_ACTIVITY_CENTER. POSTAL_LOCATION_NAME,
MAILBOX_MRA. ROUND_NAME;


1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

@Vanessa250919, ¿asumo que está utilizando este editor avanzado de conexión?

será posible obtener la consulta del historial de oracle qué consulta se disparó, esta parece estar bien, puede ser algún problema de conversión de conjuntos de caracteres

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

@Vanessa250919, ¿asumo que está utilizando este editor avanzado de conexión?

será posible obtener la consulta del historial de oracle qué consulta se disparó, esta parece estar bien, puede ser algún problema de conversión de conjuntos de caracteres

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.