Forum Discussion

SM_SHED's avatar
SM_SHED
New Member
1 year ago
Solved

Direct Query on dekstop Vs Online

Hi All,   Fairly new to power BI. I have recently built a report in power BI desktop that direct queries an sql server and a google sheet. When i publish the report for others to view online none o...
  • Anonymous's avatar
    Anonymous
    1 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.