Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
W3nd3ll
Regular Visitor

I need help sharing a Report that use Direct Query

I've built a report that is using direct queries from 2 different databases.  I am needed to share the report with others in my organization, but I am having issues doing that.  I created an on-premise gateway that does allow others to view the report, but this only work when I am logged in to my organization VPN and my computer is online.  Whenever my computer goes offline or I get disconnected from my organization VPN, others can no longer access the report.

 

Can someone please help?

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @W3nd3ll ,

About size limitation.refer the link - https://docs.microsoft.com/en-us/power-bi/report-server/whats-new

Large file upload/download

You can upload files up to 2 GB in size, though by default this limit is set to 1 GB in the Report Server settings in SQL Server Management Studio (SSMS). These files are stored in the database just as they are for SharePoint, and no special configuration for the SQL Server catalog is required.

 

Best Regards

Lucien

v-luwang-msft
Community Support
Community Support

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 😞

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.