13 - Change Database & Server name dynamically using Query Parameters in Power Bi

#PowerBi, #QueryParameters, #Powerbitutorials

Learn how you can change connection strings dynamically using Query parameters-

Youtube: PowerBiTutorials

[PowerBITutorials]

Hi,
For Video 13-
if you have sql server, then create two different different database and under both database create same table as i mentioned in videos then follow the steps.
For Video 12-
You can import any excel sheet on any table data to Power Bi then create two three visuals and according to any category you can create parameters, and if you need same dataset then visit my site download section.


from here you can download superstore us dataset.

For RLS video - You have to signup in Power Bi Pro trail version with official mail id and to cross check with other user you need other users login details as well.

[denwo]

If you were to publish this report to a Workspace on Power BI Service and the Workspace had the word “DEV” at the beginning and another workspace had the word “PROD” can you put some logic in the parameter to automatically select the server and database name based on which workspace they are in?

[agelee]

How does it look in PowerQuery advanced editor?

[TheAbisheik_]

IF you publishing the report in App.powerbi, how to change database in the published report. Pls reply to me .

[Pranav-fgjr]

I have done the same and deployed my reports on powerbi service workspace and when i go the my workspace and try to refresh my dataset then it shows invalid credentials. When i go the edit credentials, then that option is disabled. how to fix this on powerbi service.?

[shr]

Can we keep this option in the visuals so that we can change the database or server in desktop easily

[VIBHOREVARSHNEY]

Can't we do this if the souce is Databricks as am not getting the option to add parameters when choosing the source as Azure Databricks or Spark?

[radhasivan]

I'm passing parameter from c# using client.Datasets.UpdateParametersInGroupAsync(workspaceId, datasetId, updateRequest); Its working fine but when concurrent users accessing the report at same time then it's showing wrong database data. How can I resolve this?

[subhajyotibhattacharyya]

I have a table where all the customer and schema names are included in columns. I need to pull data from particular schema for particular customer. Can you please help me on how to do that

[rizkiyoga]

is that only works for sql server? i have tried using ODBC, but it didn't works... after creating parameters, and "closed and apply". i try to get data using odbc, but there is no option to choose the parameter that i created before....

[mario-t]

Thanks, can you change db type ? let say from Oracle to SQL Srver, with our without Parameters Tx

[sunithayadav]

how i can pratice this vedios (11, 12, 13) without database and maild id how can i got idea about those u pls database...pls reply me...thank u in advance

[hemanthkumar-mxfs]

How to dynamically change the server name in Oracle direct query