Forum Discussion

saj's avatar
saj
Icon for Helper III rankHelper III
4 years ago

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...
Need Help
nitishsh91's avatar
nitishsh91
Icon for Solution Supplier rankSolution Supplier
4 years ago

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's avatar
saj
Icon for Helper III rankHelper III
4 years ago

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).