Forum Discussion
Pbix dynamic parameter connection mode i.e direct query or import?
In Pbix, is it possible to create dynamic parameter to accept the connection mode as direct query or import? Our Dataset are big, when we develop in local laptop we want use the direct query after publish we want to move into import mode. Please advise how to achieve this?
bsaknop
I dont think it is possible to parameterize the storage mode. For large models, the most common approach that everyone follows is: In Power BI desktop, limit the data using parameters and publish it to power bi service and change the parameter value and load complete data into the semantic model. Once the semantic model is ready in the service then you can connect to the model and build your visuals or report content. If in case you have not created your measures before publishing the model into power bi service or if you want to make any changes to the transformations then you can use tabular editor external tool.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
1 Reply
bsaknop
I dont think it is possible to parameterize the storage mode. For large models, the most common approach that everyone follows is: In Power BI desktop, limit the data using parameters and publish it to power bi service and change the parameter value and load complete data into the semantic model. Once the semantic model is ready in the service then you can connect to the model and build your visuals or report content. If in case you have not created your measures before publishing the model into power bi service or if you want to make any changes to the transformations then you can use tabular editor external tool.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun