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 (obviously) am new to Power BI. I have created two different reports from two different data sources (databases on independent servers)... Report A pulling data from Database A located on Server A, and B for the other. In order to take advantage of Direct Query and schuduled refreshes of the data, I installed an on-premise gateway on Server C. The gateway has two Data Sources, one for Database A and the other for Database B which I believe is a legal setup. I was able then publish Report A with no issues, but when I attempt to publish report B, I receive the common Publishing Succeeded, but the published report can't connect to the data source because we were unable to find a gateway message.
The Gateway connection test on server C show that both data source connections succeeded.
I've run through tips on 'common issues' but have not had much success resolving the issues. If anyone has some experience that they could share I would greatly appreciate the help. Thank you.
Solved! Go to Solution.
Sorry for the late response. I found some additional information which led me to find tht there was a permissions issue on the data source that I was trying to use. Once that was resolved, it worked fine. Thank you.
HI @BrotherZin,
I'd like to suggest you to check datasource B setting to ensure both desktop and gateway side has similar files.
BTW, it will be help if you share more details descriptions about your scenario.(for. e.g sources, gateway connection statues to source files)
Regards,
Xiaoxin Sheng
Sorry for the late response. I found some additional information which led me to find tht there was a permissions issue on the data source that I was trying to use. Once that was resolved, it worked fine. Thank you.
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.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |