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

  Рет қаралды 8,511

Power BI Tutorials

Power BI Tutorials

4 жыл бұрын

#PowerBi, #QueryParameters, #Powerbitutorials
Learn how you can change connection strings dynamically using Query parameters-
Website: www.bibulldog.com
Fb: / powerbitutorials
Insta: / powerbitutorials
KZfaq: PowerBiTutorials

Пікірлер: 15
@PowerBiTutorials
@PowerBiTutorials 4 жыл бұрын
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. powerbidocs.com/2019/11/28/power-bi-sample-data-set-for-practice 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.
@nanda.kumar0472
@nanda.kumar0472 4 жыл бұрын
That's really cool... Thanks
@PowerBiTutorials
@PowerBiTutorials 4 жыл бұрын
Nanda. kumar 047 Thanks😊
@denwo1982
@denwo1982 Жыл бұрын
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?
@mario17-t34
@mario17-t34 2 жыл бұрын
Thanks, can you change db type ? let say from Oracle to SQL Srver , with our without Parameters Tx
@shr9417
@shr9417 Жыл бұрын
Can we keep this option in the visuals so that we can change the database or server in desktop easily
@VIBHOREVARSHNEY
@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?
@Pranav-fg5jr
@Pranav-fg5jr 3 жыл бұрын
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.?
@PowerBiTutorials
@PowerBiTutorials 3 жыл бұрын
Hi for this firstly you have to install on premises gateway, then edit credentials option will be enable for you.. Watch Install gateway video from playlist.
@rizkiyoga9704
@rizkiyoga9704 Жыл бұрын
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....
@subhajyotibhattacharyya4807
@subhajyotibhattacharyya4807 2 жыл бұрын
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
@radhasivan4411
@radhasivan4411 9 ай бұрын
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?
@TheAbisheik_
@TheAbisheik_ 7 ай бұрын
IF you publishing the report in App.powerbi , how to change database in the published report. Pls reply to me .
@sunithayadav6660
@sunithayadav6660 4 жыл бұрын
how i can pratice this vedios (11,12,13) without database and maild id how can i got idea about those vedios.....could u pls database...pls reply me...thank u in advance
@hemanthkumar-mx8fs
@hemanthkumar-mx8fs 2 жыл бұрын
How to dynamically change the server name in Oracle direct query
12 - Query Parameters in Power Bi Desktop
5:01
Power BI Tutorials
Рет қаралды 8 М.
Power Bi : Dynamically Change Data Sources using a Parameter
24:13
孩子多的烦恼?#火影忍者 #家庭 #佐助
00:31
火影忍者一家
Рет қаралды 51 МЛН
DO YOU HAVE FRIENDS LIKE THIS?
00:17
dednahype
Рет қаралды 105 МЛН
Power BI Quick Tip: Using Dynamic M Query Parameters with SQL​​
24:59
Data Platform Central
Рет қаралды 30 М.
Dynamic Power BI reports using Parameters
12:21
Guy in a Cube
Рет қаралды 394 М.
How to Use PYODBC With SQL Servers in Python
15:56
Sigma Coding
Рет қаралды 102 М.
孩子多的烦恼?#火影忍者 #家庭 #佐助
00:31
火影忍者一家
Рет қаралды 51 МЛН