Need help with data modelling

[macomaco]

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 for getting the data but doing filtering in Power BI using the slicer takes too long to load. I loaded the data in "Import" mode as the groupings and custom columns aren't supported in "DirectQuery" mode. Also if it may help you. I have tried loading the query in DIrectQuery but prompts an error saying "Couldn't load schema", I'm thinking this is because of the old version of the database as it is from SQL Server 2005. I hope someone can help me with this issue. Any help would greatly be appreciated. If you need more information such as the query I'm currently using I will provide it immidiately. Thanks in advance

[v-huizhn-msft]

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]

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]

Hi @macomaco,

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

Thanks,
Angelia