Forum Discussion
how to bring in data from a database by using data in another database
I have 2 different database. the table in first database has 12 million records and table in second database has 0.6 million records. I need to bring in 0.6 million records from first database using...
Thanks for you reply.
I don't want to bring in all 12 million records as it consumes time and the pbix file is limited to 1 gb.
i used custom function to bring in only 0.6 million record out of 12 million records but it is consuming time.
Is there an alternate solution to bring in only 0.6 million records or how to reduce the time that custom function is taking to fetch the data