PowerBI not refreshing in Service but does in Deskstop

Question

Hello everyone,&nbsp;Since a few weeks im having an issue with refreshing a PBI report.&nbsp; One of my data sources has a type mismatch error.&nbsp;I get the following error:&nbsp;Data source errorThe following system error occurred: Type mismatch. Table: DCS Bord.&nbsp;Ive validated all the columns in the data source but cannot find any errors. The data source refreshes just fine in deskstop but does not in service.&nbsp;I think it has to do with the date columns but im not sure.&nbsp;The excel sheet source is being used and updated by a lot of people so perhaps they changed something that does not mesh well with PowerBI service.&nbsp;Any advice how to proceed would be greatly appreciated because having to republish the entire report daily is quite a hassle.&nbsp;Thank you in advance!&nbsp;&nbsp;

anonymous · Answer

Hey Gilbert good afternoon,&nbsp;I just reuoploaded the PBIX file, the refresh cancels again with the same error.&nbsp; Could it be something in the M-script?&nbsp;&nbsp;Thank you in advance!&nbsp;&nbsp;&nbsp;

anonymous · Answer

Ok guys, i think i found the issue it was definitly something in the M-script. I reconnected to the excel sheet i was using and redid my formulas and visuals. And now after publishing to PBI service everything works as it should, everything refreshes just as planned again 🙂

gilbertq · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Once you have refreshed in Power BI desktop, can you upload the Power BI file to the Power BI Service and then see if it successfully refreshes?

gilbertq · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Can you make sure that all the columns in Power Query have got their data types set?

leonardocsilva · Answer

I'm now with the same issue and I dont know how solve it. I do everything but nothing it works. Do you solved the problem?

Forum Discussion

PowerBI not refreshing in Service but does in Deskstop

5 Replies