Forum Discussion

macomaco's avatar
macomaco
Regular Visitor
8 years ago

Need help with data modelling

Hi everybody,   I need help with data modelling in Power BI Desktop. My problem is that it takes forever to load the data as the there are more than 1.5 million rows in the database. I have a query...
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi macomaco,

When you connect SQL Server through SSMS, there is no problem? When you get data from SQL Server in Direct Query, you get the error message?

Best Regards,
Angelia

macomaco's avatar
macomaco
Regular Visitor
8 years ago

Hi v-huizhn-msft,

 

I receive no errors when connecting through SSMS. I assumed it was because of the version of the database as I read somewhere before that the "Couldn't load schema" error was caused by using a really old data source with Power BI leaving no choice but to use Import instead of the DirecQuery mode.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi macomaco,

     

    Yes, if it's caused by old version. You have to use import mode.

    Thanks,
    Angelia