Forum Discussion
How to change connetion type ?
I want to change the type of connection to DirectQuery, but this item is disable for me. And how to see what type of connection is currently set Import or DirectQuery. Thanks.
6 Replies
- Mariusz
Community Champion
Hi Anonymous
Are you doing it in Query Editor or Get Data in Desktop.
You will not be able to change the connection in Query Editor as transformation is not supported in this mode, you can, however, create a new connection in direct query mode.
Please see the below.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-bw
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn- Mariusz
Hi Anonymous
I'm afraid that you will not be able to change/add an extra connection as SAP Business Warehouse connector is not supported in Composite Models as per the article below.
https://docs.microsoft.com/en-us/power-bi/desktop-storage-mode
The only option, for now, is creating a new file and copying all the visuals from the old file to the new one.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Tahreem24Super User
Anonymous ,
Go to Relationship View --> Select your desired table -->Properties pane --> Scroll down and select Advanced --> Storage Mode --> Select DirectQuery.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
