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 tabl...
Need Help
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