#PowerBi, #QueryParameters, #Powerbitutorials Learn how you can change connection strings dynamically using Query parameters- Website: www.bibulldog.com Fb: / powerbitutorials Insta: / powerbitutorials KZbin: PowerBiTutorials
Пікірлер: 16
@nanda.kumar04724 жыл бұрын
That's really cool... Thanks
@PowerBiTutorials4 жыл бұрын
Nanda. kumar 047 Thanks😊
@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?
@agelee893 күн бұрын
How does it look in PowerQuery advanced editor?
@PowerBiTutorials4 жыл бұрын
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.
@radhasivan44119 ай бұрын
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?
@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?
@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....
@subhajyotibhattacharyya48072 жыл бұрын
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
@shr9417 Жыл бұрын
Can we keep this option in the visuals so that we can change the database or server in desktop easily
@Pranav-fg5jr3 жыл бұрын
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.?
@PowerBiTutorials3 жыл бұрын
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.
@mario17-t342 жыл бұрын
Thanks, can you change db type ? let say from Oracle to SQL Srver , with our without Parameters Tx
@TheAbisheik_7 ай бұрын
IF you publishing the report in App.powerbi , how to change database in the published report. Pls reply to me .
@hemanthkumar-mx8fs2 жыл бұрын
How to dynamically change the server name in Oracle direct query
@sunithayadav66604 жыл бұрын
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