PBI Desktop going into Import Data mode

[andrmh]

Hi All,

This is a strange one, We have been using the "Change Data Source" feature for our financial system reports, to swap between development and production servers.

We connect to a SQL SERVER data source, using windows credentials.

We run Direct Query mode.

After flicking back and forth, several times, and admittedly playing a bit with credentials and all the various settings, our projects locked themselves into a "Import Data" state, that could not be reversed. Direct query was completely disabled. I could not find any setting that seemed to re enable direct query.

In the end I simply started over, recreating the project and report and everything works well again. But I'd like to know whats happening that could have lead to this scenario, as we do need  a method for swapping between servers without keeping "DEV" and "PROD" versions of a report.... effectively doing the work twice.

Thanks,

[Seth_C_Bauer · Accepted solution]

@andrmh Are you inadvertantly connecting to multiple databases? DQ only works against one database. It should be fine if it's the same db in both environments and you are just swapping connections... 

[andrmh]

This is most likely it.
Thank you.