How Do I Migrate Existing Reports to Direct Query

[CraigBlackman]

Hi,

I have anumber of exsitng reports that connect via our personal gateway and on-permise SQL server.

I'd like to migrate these to direct query (sales reports) and to use our enterprise gateway.

Is there a easy way of doing this without having to rebuild them all?

Thanks

Craig

[pqian]

@CraigBlackman Taking Import mode to DirectQuery isn't supported yet, since there are many restrictions on DQ models currently (like only one data source, query must be foldable, no calculated columns and tables, limited measure capabilities etc) . Once these restrictions are lifted (and we are working on it), we can provide an easy migration solution for conversion between the two modes.

[taumirza]

Hi @pqian

I am also having the same issue..!!

Have you guy's got any solution...??

[Greg_Deckler]

@CraigBlackman - You could try the technique suggested here:

http://community.powerbi.com/t5/Integrations-with-Files-and/Converting-an-Excel-source-to-SQL/m-p/16...

[CraigBlackman]

@Greg_Deckler

The trouble is report uses multiple tables and have multiple visualisations all from my native sql database.

[Greg_Deckler]

@CraigBlackman - Right, the same technique should apply for each query. That being said, I haven't done this technique with DirectQuery before.

[taumirza]

Hi @Greg_Deckler.

what about the measures and calculated columns we created at the report page.

will those measures and column be there, if not how we suppose to bring those back..?? should we craete all of em again...??