Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone, I have an table has 385 millions rows. Probably it would be greater. This table sit on Oracle database. Import is takes so long. What would you do? What is your suggest?
Hi @BirhanAYDS ,
Your data is too large to use Import mode. You need to use DirectQuery instead. DirectQuery connects to the data directly and its speed is much faster than Import mode.
You can refer to the following documents.
https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @BirhanAYDS ,
Can you describe the specific error that occurred when creating a relationship (eg using a screenshot)?
Here is the document about relationship, you can refer to it.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |