Forum Discussion
Power BI runs query multiple times on backend?
I'm developing a dashboard using Apache Hive as the backend storage (using an ODBC driver) and I've noticed something strange. When I add a datasource, Power BI runs the query 3 times for each ref...
Hi,
This is because of you connection is established directly to your dataset. Microsoft recomends to build tabular model, so that your data will be stored in olap engine and will throw results alone to your PBI Reports.
I'm not sure I fully understand. The way I'm pulling data (and I bet the others in the tread are) is to hook up via ODBC to hive and run an import on a table or a query that results in a "tablular" dataset. As far as Power BI should be concerned, it's the same output as hooking up to an oracle table using ODBC, or any other database.
Is the tabular model something different then an output that looks like a table (column/rows)?