Forum Discussion

IMett's avatar
IMett
Helper III
4 years ago
Solved

Direct Query behaviour with column order change

Hi everybody, I am analyzing a very weird behaviour in our data model. I tried to simplify the model as far as possible: Issue: I have 2 models, which seem absolutely identical. They have the ...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi IMett 

     

    Have you checked whether the M codes of all queries in both models are identical? You can click Advanced Editor to see all M codes of a query and compare it with the query in the other model. At present I couldn't think of other possible causes. 

     

    Best Regards,
    Community Support Team _ Jing

IMett's avatar
IMett
Helper III
4 years ago

Thanks a lot for the hints, 
Indeed, there was a key difference between the queries which I didn't recognize.

The data source is an SQL Server and on one of the queries the "SQL Server Failover" option was checked. Apprently Power BI treats this as a different data source, although it only appears once in the data source settings.

The query itself doesn't contain any logic (also no native query), so there is nothing to fold.

Query 1:

let
    Source = Sql.Database("xxx-xxxx-xxxx-001.public.xxxxxxx.database.windows.net,3342", "xxxxx"),
    BL_Vertrag_Dim_LPersonenbezug = Source{[Schema="BL_Vertrag",Item="Dim_LPersonenbezug"]}[Data]
in
    BL_Vertrag_Dim_LPersonenbezug

Query 2:

 

let
    Source = Sql.Database("xxx-xxxx-xxxx-001.public.xxxxxxx.database.windows.net,3342", "xxxxx", [MultiSubnetFailover=true]),
    BL_Vertrag_Dim_LPersonenbezug = Source{[Schema="BL_Vertrag",Item="Dim_LPersonenbezug"]}[Data]
in
    BL_Vertrag_Dim_LPersonenbezug

 

Pretty tricky to be honest!
It would be great if those data sources could also be displayed separately  in the data source settings.