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
mh2587's avatar
mh2587
Super 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 ) ?