cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Convert from imported data to direct query

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Convert from imported data to direct query

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.

View solution in original post

1 REPLY 1
Highlighted
Resolver I
Resolver I

Re: Convert from imported data to direct query

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.

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!