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