Forum Discussion
Helper IIGateway not configured for a single report
It is really hard to tell from the screenshots the server and database name, but they must match exactly with that used in your published report. For the one that works, it looks like the server name is much longer than the one that doesn't work.
Some how it exists in your source file. You'll need to open up your pbix file and either remove or update the queries that are using the incorrect source.
In the ribbon, select "Transform data". In the query editor ribbon, select "View", then "Query Dependencies" to find the culprits.
The above comment from blopez11 did the trick along with this information
The data source settings in Power BI desktop need to match those set up in the Gateway
Here is how to view the data source in the Power BI Report
- In Power BI desktop, open the report
Open Power Query Editor - Go to View tab
- Select Query Dependencies
- In Power BI desktop, open the report
Super User
Please open manage connections and gateways page, this link should directly take you there: https://app.powerbi.com/groups/me/gateways?experience=power-bi
Look for the connection which was created by your infra team. If you open the connection you will find the server hostname and database name entered by them while configuring the connection. Please match them with the datasource that you used in your new report. If those are not same then you need to ask your infra team to configure a new connection for you.
If you could not find the connection then that means you do not have access to the connection and you need to ask your infra team to add you as a user into that connection.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Helper IIThe data source server and dbname match for many reports, including the new one. Does this mean that every time I publish a new report, I need to contact the Infra team to create a connection to my existing datasource?
blopez11It is really hard to tell from the screenshots the server and database name, but they must match exactly with that used in your published report. For the one that works, it looks like the server name is much longer than the one that doesn't work.
- SarahHope
The above comment from blopez11 did the trick along with this information
The data source settings in Power BI desktop need to match those set up in the Gateway
Here is how to view the data source in the Power BI Report
- In Power BI desktop, open the report
Open Power Query Editor - Go to View tab
- Select Query Dependencies
- In Power BI desktop, open the report