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...
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