topic Direct Query Report - Solution to share with multiple users without multiple data refreshes in Developer

Direct Query Report - Solution to share with multiple users without multiple data refreshes

Mukesh_Patel — Tue, 25 Jun 2024 13:44:53 GMT

Hello,

I'm working on a report that uses Direct Query (SQL) and the report has Card visuals and is not interactive.
Refreshing each visual sends a new set of queries to the underlying source and there are many users who require access, which eventually is a significant load on the data source.

Is there a solution that can run a single instance of the report that can be viewed by multiple users?

Re: Direct Query Dashboard - Solution to share with multiple users without multiple data refreshes

lbendlin — Mon, 24 Jun 2024 19:36:34 GMT

Please consider using the Power BI terminology. There is a difference between a report and a dashboard. Direct Query is not the same as Live connection.

Dashboards are designed to be shown on a hall monitor, and they update whenever the underlying semantic model is updated. No user interaction is required. This also means that dashboards are mainly designed for import mode or push data sources.

Please describe your scenario again.