Error when publishing PBIX file - Publishing is complete. However, we couldn't refresh your dataset
Hi Dale,
When reproducing, did you use a report/dataset that already existed in the Service. If you publish a completely new report, the issue will not occur. Answers to your questions are below:
1. What's the mode? Import or Direct query?
Import
2. Did you upgrade the Data Gateway?
Checked our current data gateway version and it is 14.16.6464.1. Is there a newer version?
3. Did you create the data source of the Gateway in the Service?
Yes. The data source for this Gateway exists.
4. What's new of the new version?
I have added additional visuals and report pages to the report.
5. Did you change the password of the credential of Sql Server?
No
6. Did the Sql Server allow the remote connect? and the TCP/ip connection?
Yes
7. Can you manually refresh the dataset?
No. When I press the refresh button, the yellow warning sign stays in place.