Data Connectivity Modes

You can connect to a SingleStore data source using the SingleStore connector in Power BI in the following modes:

In Import mode, Power BI imports the data from the data source. If the data in the data source changes after the initial import or the latest refresh, you will need to refresh the data source to see the changes.

In DirectQuery mode, data is not imported into Power BI and you work directly with the data source. See Use DirectQuery in Power BI Desktop, for more information on DirectQuery mode.


In personal mode, the on-premises data gateway can only be used together with Import mode. For more information, see Use personal gateways with Power BI.

If you see an Invalid credentials error while using the on-premises data gateway in personal mode, upgrade the SingleStore Direct Query connector to the latest version.

Last modified: February 6, 2023

Was this article helpful?