Gateway not working for certain users

Hi Anonymous ,

What's your data source and connection mode? 

For example, the PBIX file connected to the SQL SERVER data source through DirectQuery is uploaded to the Power BI service, and the gateway must be configured to view the visuals of the report.

DirectQuery is a direct connection to data source. Data will NOT be stored in Power BI model. Power BI will be a visualization layer, then query the data from data source every time. Power BI will only store metadata of tables (table names, column names, relationships…) but not the data. Power BI file size will be much smaller, and most probably you never hit the limitation of the size because there is no data stored in the model. 

When the data source of DirectQuery is on the Power BI service, the report will not be able to access the data source without configuring the gateway.

For more information about the connection mode, please kindly refer to:

DirectQuery, Live Connection or Import Data? Tough Decision!

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.