Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |