Direct Query on dekstop Vs Online

[SM_SHED]

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 of the visuals are visible and there is a red ribbon on top that says "We are unable to access some data sources because the artifact is missing connection details. Please contact the artifact owner to bind the data source connection or us..."

Can i not use direct query and an online report for others to view or is there different way i should be publishing the report. I would like others to be able to use the filters i have a pllied to different pages.

Thansk for your help

[Anonymous]

Hi @SM_SHED,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[lbendlin]

If your SQL server is on premise then you need to use an Enterprise gateway.

To refresh the credentials go to the settings page of the semantic model and open the "data source credentials" section.