Source as a parameter against Google BigQuery

[Anonymous]

Hi,

I want to set the data source as a parameter, this is due to ALM toolkit not detecting some changes when I connect to the live dataset. Also due to having multiple fact tables. 

I want to set it up as the image below but setting it as a list won't work either, anyone knows how to deal with it? I tried a different approach with just setting Billing project and APIstorage as a parameter but then it errors out regarding "Record".

Appreciate the help if anyone knows how to deal with it!

Kind regards,

Jari 

[Anonymous]

@Anonymous 

Check the example of using parameter to get different databases in SQL. You could set the same parameter for Google BigQuery. 

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4 - Simple Talk (red-gate.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.