Forum Discussion

abde139's avatar
abde139
Frequent Visitor
2 years ago

Import query from Oracle based on the data from extarnal table

I am new to power BI. Sorry if my question may be trivial.   I have data imported from azure cloud which contains about 1 000 lignes. Id_cloud score 1 0.8 2 0.3   I also have data...
Need Help
abde139's avatar
abde139
Frequent Visitor
2 years ago

Thanks mh2587  for your efforts and detailed answer. I just have a concern with the 2nd step: "Filter the Oracle Data" . It indicates the use of the "Filter Rows" transformation, does it means I should select manually all the required ID from Cloud table and filter the Oracle table ?

mh2587's avatar
mh2587
Icon for Super User rankSuper User
2 years ago

I think first merge it and filter the data if any blanks occure

  • abde139's avatar
    abde139
    Frequent Visitor
    2 years ago

    Thank you mh2587, in fact to perform the merge, the data should be uploaded first and that is the problem, it is too heavy to upload 100M lignes and then perform the necessary treatement. Is there a way to upload just the necessary lignes ( using SQL query while importing  for example ) ?