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?
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.?
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.
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....
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?
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
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
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.
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?
That's really cool... Thanks
Nanda. kumar 047 Thanks😊
How does it look in PowerQuery advanced editor?
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.?
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.
Can we keep this option in the visuals so that we can change the database or server in desktop easily
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....
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?
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?
Thanks, can you change db type ? let say from Oracle to SQL Srver , with our without Parameters Tx
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
IF you publishing the report in App.powerbi , how to change database in the published report. Pls reply to me .
Hi, It will only work at Desktop level.
How to dynamically change the server name in Oracle direct query
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
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.