Convert from imported data to direct query

[BeachPerson]

I am using the May 2020 Power BI Desktop release optimized for Report Server.  I want to convert a report from using imported data to direct query with Snowflake.  I know that I can connect to Snowflake in a target report, set up the model, and then copy/paste visuals from the source report to target.   But I'd rather just delete the imported tables in the source report and connect to snowflake from there.   I have tried deleting all tables in the source so there is no data in the report.  However, when I connect to Snowflake, the option for Direct Query is disabled.  I have tried closing and reopening the report but still seeing the issue.  There is something in the report that says the storage mode is import even though I have deleted all of the tables.  Any ideas on a workaround?

[DavisBI · Accepted solution]

Hi,

This is a known bug in this version of PBID. Before the bug is resolved, try to avoid converting the import mode to DirectQuery mode. You can now try to save the report as PBIT, then open it again and use DirectQuery to connect to Snowflake. If the problem persists, you may need to start a new .pbix file and redo the report.