- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Refresh Issue in Power BI Service Due to Type Mismatch
Hello All,
I’m encountering a data refresh issue in Power BI Service. I’ve created a Power BI report that publishes successfully, but when I schedule an automatic refresh or try to refresh manually on the service side, I receive an error indicating a type mismatch in one of my tables.
The table in question is coming from SQL Server, and here’s the M-query I’m using in Power BI:
And this is my M-query for that particular tbale in PowerBI .
let
Source = Sql.Database("***********", "********"),
dbo_BSEG_FI_New = Source{[Schema="dbo",Item="BSEG_FI_New"]}[Data],
#"Sorted Rows" = Table.Sort(dbo_BSEG_FI_New,{{"H_BUDAT", Order.Ascending}}),
#"Changed Type" = Table.TransformColumnTypes(#"Sorted Rows",{{"H_BUDAT", type date}})
in
#"Changed Type"
I’m trying to identify the root cause of the type mismatch error so that I can successfully schedule an auto-refresh for this report without any issues. Could you please help me figure out the potential reasons for this error and how to resolve it?
Any guidance would be greatly appreciated!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-28-2024 10:13 AM | |||
07-17-2024 08:43 AM | |||
07-16-2024 01:44 PM | |||
06-30-2024 12:20 AM | |||
05-29-2024 08:06 PM |
User | Count |
---|---|
26 | |
24 | |
13 | |
10 | |
9 |
User | Count |
---|---|
50 | |
41 | |
24 | |
19 | |
16 |