Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am trying to setup parameters (for Azure Databricks Datasource DEV, TEST & PROD) in dataflows in Power BI Service. They are not visible under Dataset/Semantic Model settings. What am I missing here? Please refer screenshots.
How do I do that? M-query does not show the dataflow name to replace it with parameter.
Hi @tjravi2828
It is not the Dataflow that you need to parameterize. it is the entity.
These are the "Entities" of a Dataflow
So let's you create a Dataflow in a Workspace. In the Dataflow you will add one entity for each server or environment (Dev, Test, Prod). When you Get Data in your desktop to build your dataset, In Power Query you create parameters for each Entity.
In your case where you have 3 Workspaces (Dev,Test and Prod) with 3 Dataflows, you will then create parameters for each Workspace ID and Dataflow ID. I hope you know where to get the IDs .
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @tjravi2828
Dataflows storage is ADLS(Azure Data Lake Storage) therefore the parameters you have created are applied to the ADLS and when you call the Dataflow from your desktop (Through semantic model) you import the data that is already parameterized.
I think if you want to switch between 2 hostnames in Databricks then you create 2 Dataflows (One for each Host) and then create parameters in the semantic model to switch between the 2 of them.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
User | Count |
---|---|
36 | |
31 | |
28 | |
25 | |
25 |
User | Count |
---|---|
52 | |
51 | |
36 | |
36 | |
29 |