Forum Discussion
I need help sharing a Report that use Direct Query
Hi W3nd3ll ,
Direct query works by linking directly to the data source to get the latest data. When the user clicks on the report, it sends the request to the data source to get the data, while when you are offline, you cannot access the report because you cannot get the latest data. This is by design. If you want users to be able to access the report at any time, you can use 1. data stored on the web, such as Azure SQL. 2. the connection method is switched to import, but with import, there is a lag in the data of the report.
refer:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
Hi W3nd3ll ,
Direct query works by linking directly to the data source to get the latest data. When the user clicks on the report, it sends the request to the data source to get the data, while when you are offline, you cannot access the report because you cannot get the latest data. This is by design. If you want users to be able to access the report at any time, you can use 1. data stored on the web, such as Azure SQL. 2. the connection method is switched to import, but with import, there is a lag in the data of the report.
refer:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
Thanks for the response. Sounds like my best option is to import instead of direct query, but another issue is that the data is pretty large so I can't even import 😞