Using the Connector
The CData Power BI Connector for SFTP interfaces Power BI's two modes for Querying Data:
- DirectQuery: Visualizing data in real time by connecting directly to the data at the source.
- Import: Embedding data in a report, which can be refreshed on demand. This is the most common way to get data. Importing data takes advantage of the Power BI query engine.
Once you have connected and gained access to the data, you can begin Visualizing Data. Create and refine visualizations by defining filters, aggregating data, and joining tables when working with remote data.