Forum Discussion

cjones's avatar
cjones
Advocate I
10 years ago

Changing a Direct Query Power BI Model without Importing all data

Hi,   We have a Azure SQL DB which our Power BI connects to via Direct Query.   We want to add an additional dimension to the Power BI model which exists in the DB but when I try to add it Power ...
pqian's avatar
pqian
Microsoft Employee
10 years ago

cjones, currently all DQ data must come from the same database (also case sensitive)

 

Can you open the queries editor (Edit Queries), and then see how many queries you have in there? For each of the queries, can you go to View->Advance Query Editor and paste their M formula here? I can diagnose the problem better if I can see the queries.

  • cjones's avatar
    cjones
    Advocate I
    10 years ago

    Hi pquian,

     

    Your statement -> currently all DQ data must come from the same database (also case sensitive) was the key.

     

    I checked both database statements and one of them explicitly mentioned port 1433 whereas the other just stated the database name (as the default is 1433 the connection worked fine).

     

    Apparently, this difference was enough for Power BI to think that it was a new different database and force the reimport.

     

    Thanks for your help!

    • pqian's avatar
      pqian
      Microsoft Employee
      10 years ago

      Yes, unfortunately we currently have to put in this restriction based on the user supplied connection info. We are working on lifting this restriction in the future.

       

      Glad your problem is solved :)

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      How do I you solve this?