Forum Discussion

WalkerGBG's avatar
WalkerGBG
Frequent Visitor
4 years ago

DAX Column Error - "String Store or binary store with a compatibility level of '1050' after loading

Hi   Searched lots on Google and can see this mentioned but not in relation to PowerBI so wondering how spectacularly I've broken it.   I have a DataFlow that pulls in Daily (using Incremental re...
Need Help
WalkerGBG's avatar
WalkerGBG
Frequent Visitor
4 years ago

Alas not fixed

Abubu's avatar
Abubu
Regular Visitor
3 years ago

I have just ran into this problem of yours... Same exact message after creating a summary dax table of a very large data table.

It's very frustrating.  The computer has tons of memory available, and all power BI settings are good.

 

My Power BI desktop is updated.

 

Walker,

If I find a solution, I'll come back here.

  • Abubu's avatar
    Abubu
    Regular Visitor
    3 years ago

    Walker,

    Does your Power BI File have any sort of connection with a SQL Database?  Even though you are currently using Desktop, and the data isn't from a SQL Database... HOWEVER, is there any connection elsewhere in your file or dataflow?

     

    I have not solved anything yet, it's just that it appears the issue stems from the way strings are stored in a SQL Database.  I personally am not dealing with a SQL Database directly, however, some of the associated data comes from a SQL Server, and somehow, perhaps the SQL server is doing some of the calculations, even though I had assumed it was all upstream, and not relevant.

     

    Here is the Microsoft Doc I am trying to pick apart:  https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/configure-string-storage-for-dimensions-and-partitions

     

    It appears that a setting or parameter can be changed in the SQL Server to allow for larger strings.  Whatever that means. 🙂

     

    Here's hoping!!