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 view the changes.

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

Note

In personal mode, the on-premises data gateway can only be used together with Import mode. For more information, refer to 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:

Was this article helpful?