Forum Discussion

aka's avatar
aka
Icon for Helper II rankHelper II
9 years ago

direct query to import

hi guys,   Ihave like 86 millions rows in my fact  along with few dimensions and i want to chage it from direct query to import i tried doing that but getting an error, any idea how to approch thi...
Need Help
aka's avatar
aka
Icon for Helper II rankHelper II
9 years ago

Greg_Deckler

this is how m changing and after loading some of the 33 millions rows am getting error like data sourse connection closed( am trying once agian if get the error again i will take a snap shot)

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

You may be running into a data model size limitation. What happens if you just create a brand new Desktop file and connect to the data source and do an import (could even copy over your query using Advanced Editor)

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi aka,

    You'd better check if the error was caused by the size limitation according to Greg_Deckler posted. Please feel free to ask if you have other issue.

    Best Regards,
    Angelia