Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago

Dual Storage Mode

Hi all,

 

Using PBI Desktop Report Server 2.93 May, 2021.

I have 1 table that is in Direct Query Mode to SQL Server

Now I would like to import a small table

But when I try to import the new table, PBI warns that the other table will will be swtiched to Import Mode

 

How do I stop this so I have 1 table in Direct Query Mode and the other Import Mode?

 

Thanks,

-w

Need Help

9 Replies

  • UncleLewis's avatar
    UncleLewis
    Responsive Resident
    4 years ago

    Thanks Amitchandak,

     

    I sent a request to our software distribution team to check on upgrade of PBI Desktop.

    To get data from an Excel Workbook as a new Data Source in Import Mode I did:

    Get Data >> Excel >> Select File >> Select Sheet1 from the wb >> Transform

    This is where I get the warning: Switch to Import Mode.

     

    Thanks,

    -w

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    UncleLewis it is ok to get the warning message since excel will be always in import mode and asking if you want another source in import too, it is just a warning and say No to it.

     

    This is supported in May 2021 if you don't get to the latest version, although always preferred to the latest version but this feature is quite old now and should work with May 2021 release.

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

     

    • UncleLewis's avatar
      UncleLewis
      Responsive Resident
      4 years ago

      Thanks Parry2K,

       

      The only buttons available on the Switching to Import Mode Dialog are Switch or Cancel.

      If I cancel, the Excel wb is not imported.

      If I Switch, The DQ Table will be imported.

       

      Are there other settings or options I need to look at?

      Thanks,

      -w

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    UncleLewis I'm a bit confused, as a matter of fact, you shouldn't get that warning. Are you merging DQ table with import table? 

    • UncleLewis's avatar
      UncleLewis
      Responsive Resident
      4 years ago

      Thanks Parry2k,

       

      No, not trying to merge tables.
      Just trying to have 2 Tables in the model for now.

      One table is Direct Query Mode.

      The other table is Import Mode.

       

      Thanks,

      -w

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    UncleLewis I just tested at my end and not even getting the warning message anymore which I expected and I tested it in April 2021 (prior to the version you are using), not sure why you are getting that message. Can you confirm the Power BI version again?

    • UncleLewis's avatar
      UncleLewis
      Responsive Resident
      4 years ago

      Thanks Parry2K,

       

      I'm using Power BI Desktop Report Server

      Version 2.93 May, 2021.

       

      Could this be a setting set by Corp Power BI Admin?

       

      Thanks,

      -w