Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago
Solved

How do i convert Import to Direct query mode for Common Data Source Connection

Hi Team,   I have created the reprot connection as Import and devloped a new report. Now i want to change my connection from Import to direct query because of live data present in the report when c...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi prakash11440278 

    I am glad that you can find a workaround to solve your problem. 

    Could you kindly accept the helpful reply as a solution? More people will benefit from it.

     

    Best Regards,

    Rico Zhou

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi prakash11440278 

What kind of data source do you get data from?

I have a test by SQL Sever, it works well.

I get data (table named School) by import connection mode.

Then I get data source in Power Query again by Direct Query (Table named School(2)).

Delect School and rename School(2) as School.

The visual works well and show connection mode in Direct Query.

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago

Hi Anonymous ,

I am using CDS import connection. When inital time it is asking the connection method, after i import the tables and again i tried it is going into import mode and not showing direct query option.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi prakash11440278 

    Please refer to this blog for more details: DirectQuery CDS from Power BI

    I hope it could help you solve your problem.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

     

     

    • prakash11440278's avatar
      prakash11440278
      Post Prodigy
      5 years ago

      Hi Anonymous ,

      Thanks for your reply.

      This is not a recommended method for production environment.

      I have a workaround this by using power flows.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi prakash11440278 

        I am glad that you can find a workaround to solve your problem. 

        Could you kindly accept the helpful reply as a solution? More people will benefit from it.

         

        Best Regards,

        Rico Zhou