Forum Discussion
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 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
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.
4 Replies
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.
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.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.
