Forum Discussion
rocky09
9 years agoSolution Sage
Working with Large Data
Just want to know, How you guys work with Large Data? 1. Do You completely imports all the tables from database like SQL, Oracle into PowerBI. 2. Do You create a new table with SQL query (combin...
v-sihou-msft
9 years agoMicrosoft Employee
I suggest you separate date into multiple views to import. Or use Direct Query instead of import mode.
Reference:
Data Import Best Practices in Power BI
Regards,
rocky09
9 years agoSolution Sage
Thanks for the link. Most of the content helped me.
I am using individual queries to get the data from the server. But, sometimes, I am missing a common column in tables. So, I am not able to make relationships with it. Is there a way to create a custom common column ?
- v-sihou-msft9 years agoMicrosoft Employee
I don't know what your common column looks like. You can add custom columns like index column.
Regards,