Forum Discussion
Direct Query on dekstop Vs Online
- Anonymous1 year ago
Hi SM_SHED,
Thank you for reaching out in Microsoft Community Forum.
Thank you lbendlin for the helpful response.
Please follow below steps resolve the issue;
1.Configure Gateway for SQL Server
Go to Power BI Service → Settings → Datasets → find your dataset.
Under Gateway connection, configure an On-premises Data Gateway for the SQL Server connection.
2.Set Credentials for Google Sheets
Still under Settings, look for Data source credentials.
Re-enter your Google Sheets credentials and choose the correct authentication method (usually OAuth2).
3.Ensure Privacy Levels Are Compatible
Mismatched privacy levels across sources (SQL Server & Google Sheets) can cause issues.
You can adjust them under File → Options → Current File → Privacy in Power BI Desktop before publishing.
4.Re-Publish the Report After Configuring Connections
Once all data source bindings and credentials are correctly set, republish your report, and visuals should load successfully for all users.
Please continue using Microsoft Community Forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
Hi SM_SHED,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.