I'm totally new to data analytics domain. Till now I was learning Power Bi and SQL. Could you please help me understand how tableau gone help me further?
hi, I hv a query, plz reply to the same. if there is a live connection, how can the data be previewed in the tableau? In powerBI, we can't even see the data in live or directquery connection but here in Tableau, not only the metadata we could also see the preview of data. why is this so and what is the mechanism followed in Tableau during live connections. ItI plz do reply. it would be of great help.
@Jyotshna: The ability to preview data while using a live connection in Tableau versus Power BI's Direct Query mode is due to differences in the underlying architecture and approach of the two tools. Tableau's Live Connection: Tableau establishes a direct connection to the data source when using a live connection. This means that Tableau interacts directly with the data source in real-time, allowing for dynamic exploration and analysis of the data. As a result, Tableau can provide a preview of the data during the connection setup process, as it has immediate access to the data source. Power BI's DirectQuery Mode: In Power BI, the DirectQuery mode operates differently. Instead of establishing a live connection directly to the data source, Power BI sends queries to the underlying database in real-time based on user interactions with the report or dashboard. This approach enables Power BI to leverage the full capabilities of the database engine and work with large datasets. However, it means that Power BI doesn't have immediate access to the entire dataset for previewing during the connection setup process. In Direct Query mode, Power BI relies on metadata and schema information available from the data source to provide a preview of the fields and their structure. This preview typically includes information such as column names, data types, and initial sample data. However, it doesn't display the complete dataset because the actual data retrieval occurs dynamically during report interaction.
Thank you so much 🙏
I'm totally new to data analytics domain. Till now I was learning Power Bi and SQL. Could you please help me understand how tableau gone help me further?
hi,
I hv a query, plz reply to the same.
if there is a live connection, how can the data be previewed in the tableau?
In powerBI, we can't even see the data in live or directquery connection but here in Tableau, not only the metadata we could also see the preview of data.
why is this so and what is the mechanism followed in Tableau during live connections.
ItI
plz do reply. it would be of great help.
@Jyotshna: The ability to preview data while using a live connection in Tableau versus Power BI's Direct Query mode is due to differences in the underlying architecture and approach of the two tools.
Tableau's Live Connection: Tableau establishes a direct connection to the data source when using a live connection. This means that Tableau interacts directly with the data source in real-time, allowing for dynamic exploration and analysis of the data. As a result, Tableau can provide a preview of the data during the connection setup process, as it has immediate access to the data source.
Power BI's DirectQuery Mode: In Power BI, the DirectQuery mode operates differently. Instead of establishing a live connection directly to the data source, Power BI sends queries to the underlying database in real-time based on user interactions with the report or dashboard. This approach enables Power BI to leverage the full capabilities of the database engine and work with large datasets. However, it means that Power BI doesn't have immediate access to the entire dataset for previewing during the connection setup process.
In Direct Query mode, Power BI relies on metadata and schema information available from the data source to provide a preview of the fields and their structure. This preview typically includes information such as column names, data types, and initial sample data. However, it doesn't display the complete dataset because the actual data retrieval occurs dynamically during report interaction.