Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a dektop report and published it to its own app. I have set up the gateway server for the on prem refresh of the SQL server the report pulls data from.
However we have run into an error when we try to set up the data sources on the gateway.
I have set up the SQL server and the gateways server can connect to it fine, however why i try and enable gateways for the dataset i get the below error:
This is telling me that i haven't added the SQL server, but i have, it is a data source and the gateway is already connected to it.
Any ideas what im doing wrong?
Solved! Go to Solution.
So i fixed it!
In my desktop report the data source name had an additional '\' on the end of the server name. I removed this to match the server name i used in the gateway and it worked.
Ensure the datasource you use in the report and the Gateway match exactly.
The data source setup in the service for the gateway must be setup exactly as you refer to it in your pbix file, including the username
So i fixed it!
In my desktop report the data source name had an additional '\' on the end of the server name. I removed this to match the server name i used in the gateway and it worked.
Ensure the datasource you use in the report and the Gateway match exactly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.