Forum Discussion
Report is not refreshing data
Yes
Follow all the steps i mentioned previously, Please
aj1973 When I am on this screen:
and click Test all connections it doesn't show any porblems.
What else I do I need to do?
< use the same credentials (when connecting Desktop to the source)
I am not providing any credentials when I am connecting to my data. I am using DirectQuery
Hi Markzolotoy
DirectQuery or Import mode is the same, doesn't matter.
Let's do this step by step
In your desktop can you refresh your report without a problem? if so then verify this
Then go to the workspace where you published the report and enter to your Gateway and verfiy that the Data source is added correctly:
Server name, Source and authentication methode need to be the same as the desktop
Once the connection is successful go to the Gateway settings connection and configure it to Map it to your data source settings
Finally verify the Data source credential
If all is good then your Gateway should be ready to go.
Let me know how it works out for you
Do I have to add a data source to the dataset and map it?
Yes
Follow all the steps i mentioned previously, Please
I actually did and I got it working. I then published the same report to another workspace which created new entry in Reports and in Datassets of that workspace. However I did not add a data source to the new dataset. should I do it for every workspace?