Forum Discussion
saj
4 years agoHelper III
Error on Service not on Desktop
Has anyone come across an issue where the Desktop version of a dataset refreshes fine but the service version keeps failing? I've got a dataset that has been refreshing every day for several mont...
nitishsh91
4 years agoSolution Supplier
Hi saj
Are you using an excel file in your dataset and does it have dyanmic column names or something adn you are removing columns in the query?
saj
4 years agoHelper III
Hi nitishsh91 thanks.
No it's SQL but either way the refresh succeeds in Power BI Desktop and fails in the Service (same source data).