Forum Discussion
Data Refresh Issue in Power BI Service Due to Type Mismatch
I think the issue was with PowerBI file. Then I again recreated the same powerBi and I am able to shedule a refresh in PowerBI Service.
Hi Dhruv_Ranpura ,
Please ensure the data source column types should be same data model column type. For debugging and identifying the root cause, I suggest pull it from view rather than table. In the view, type cast the error prone columns specifically datetime related fields.
Thanks,
Pallavi
Hi pallavi_r ,
Thank you for your response.
I tried to create view for that table where I typecasted the date field from nvarchar to date datatype and used that view instead of original table. And then I publised that report to service it got published successfully. But, after publishing report when I am trying to refresh from service side I again got the same error.
"Data source errorThe following system error occurred: Type mismatch. Table: BSEG_FI_New."
I try one different way too I created one blank report where I connected that newly created view and created one sample visual using some fields from that view and published that report. And, also tested to refresh that sample report from PowerBi service side it gets refreshed successfully.
So, what to do?
Good that you tried with this approach. If you have already verified the type conversion in data source, power query transformation and model, then the probable cause could be in any of the following.
a) verify that any relationship with this table should take place using matching data types.
b)verify all dax and calculated formulas associated with table is taking place with matching data type
c)if datasource has null values, then make sure model handles it correctly with default value or as per the requirement.
Can you please check these 3 points and let me know.
Thanks,
Pallavi