Power BI User on 11 Aug 2015 00:36:50
Once you create the Dataset, you can't change anything. I would like to be able to edit the following:
a. Dataset name
b. Server
c. Database
d. Service account
e. Associate to a different Personal Gateway.
I manage a team of developers who ideally need to be able to write a report in Power BI Desktop, setup their dataset, publish the report to the Power BI portal, and then change the Dataset to use the central server's Personal Gateway. With the way this is currently configured, each user has to setup up their own Personal Gateway which is then persisted in the report. So now I either have to force the users to log into a single server to do their development, or live with the fact that each machine can be a point of failure for our refresh if it is powered down or offline. The current setup is not ideal. If you could basically duplicate functionality of using a local dataset for local development and optionally deploy over a dataset on a server (like a SSRS data source) and allow editing of the server version of the dataset (like a SSRS data source), then you would have the functionality I need.
- Comments (3)
RE: Personal Gateway Dataset Editing
This is a necessity for the work I am doing.
I need to do exactly what is described above.
Create file on Power Bi Desktop publish and then redirect the service to my enterprise gateway that is already setup on the local machine under my user account.
I have connected via vpn to the machine using an internal ip address, built out the dashboard, published it and now have no ability to connect it to my gateway installed on the on-premises machine.
RE: Personal Gateway Dataset Editing
This is a great idea and one that the PBI Development team at Microsoft should seriously look into. While I fully agree with everything the author of this idea has suggested, my own situation more closely parallels Kirk's scenario below. Like Kirk, I need to be able to change the path for .xlsx, .csv and .txt files etc, but can't currently do that. I'm at a loss to understand why MS would provide the capability to change the data source in Desktop, but not provide the same capability in Service. This might sound a bit simplistic, but right now, we have an edit box with the path greyed out. Wouldn’t a drop-down list overcome this issue? Hopefully, someone from the Power BI Development Team reads this and can provide us with an answer and their also their thoughts on this very worthwhile suggestion.
RE: Personal Gateway Dataset Editing
To add to this suggestion, we need to be able also change the path to files like .csv, .txt etc when setting up the refresh schedule.
If you think of standard dev / QA / Prod scenarios it would be common for the server name(s) and references to files to change. In my case I developed on my own machine. Then moved the .csv and .pbix files to the customers PBI Group OneDrive. As you can imagine the connections/paths are different, I had to have the customer, download and open the .pbix file and change the path to the OneDrive location for the .csv files, then use “Import - Files” to load the .pbix file into the PBI Group. It would have been easier to edit the path in the Personal Gateway Scheduling screen.