Forum Discussion
Invalid Connection Credentials during Dataset refresh
Hi!
I think that my problem is related to the update...
I open the .pbix file from the Desktop and publish it. Then I refresh the information but in the report refresh only the data, not the calculated columns...
The solution is to publish the report again but I want that the report refresh automatically...Any idea what I should do?
Hello,
Your calculated columns should display when you publish. At least that's been my experience. I'm not sure of why they require a refresh.
Aside from that, you can setup a scheduled refresh as long as your data is stored in OneDrive, SharePoint Online, or you have a Personal Gateway setup. Any of those options will allow you to configure a 'scheduled refresh' (which is setup in the Service, not the Desktop).
Hope that helps