Forum Discussion

leJuan5150's avatar
leJuan5150
Helper I
8 years ago
Solved

Dataset Refresh Error : The data types varchar and uniqueidentifier are incompatible

Hi There,   As of 2017/09/14 we began to experience the following dataset refresh errors in the Power BI Service:     Neither the database schema or Power BI report were changed and the re...
Need Help
  • njrandell's avatar
    njrandell
    8 years ago

    I'm seeing exactly the same - stopped working on the 13th September. 

     

    I've got it working by calling the Text.From function (https://msdn.microsoft.com/en-us/library/mt186370.aspx)

     

    = Table.AddColumn(#"Filtered Rows", "Content Key", each [VenueId] & "#" & [ContentId])

     

    to 

     

    = Table.AddColumn(#"Filtered Rows", "Content Key", each Text.From([VenueId]) & "#" & [ContentId])

     

njrandell's avatar
njrandell
Helper I
8 years ago

I'm seeing exactly the same - stopped working on the 13th September. 

 

I've got it working by calling the Text.From function (https://msdn.microsoft.com/en-us/library/mt186370.aspx)

 

= Table.AddColumn(#"Filtered Rows", "Content Key", each [VenueId] & "#" & [ContentId])

 

to 

 

= Table.AddColumn(#"Filtered Rows", "Content Key", each Text.From([VenueId]) & "#" & [ContentId])

 

leJuan5150's avatar
leJuan5150
Helper I
8 years ago

I spoke to Microsoft support and they confirmed this issue is due to a design change to improve direct query performance against SQL Server.  No ETA for a fix as of yet.

Text.From is a good work around.