Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'm realatively new to power bi so I'm likely to have missed something basic.
For some context:
My Power Bi report draws data from excel files located in a folder on our companies local server.
Prior to the below I had already downloaded the enterprise on premise gateway (not the personal mode).
I have been given admisnitrator access rights to our server.
I have added myself as administrator to the gateway cluster.
So,
Once i published this report to our workspace app I created our gateway cluster - tested it and it shows online (with the green tick)
I then went to add the data source to the foler on our server.
I added the data source name (named the same as my report), selected 'folder' under data source type, copy and pasted the file path, entered my user name and password and clicked 'add'
This error comes up:
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance.
I am not sure whay this is happening as I think I have followed all the steps correctly.
Note - A previous employee (who has since left) had created the exact same report and had it working using an on-premise gateway (personal mode). The source data has not changed and the report is the same. The only difference is that I am using the enterprise gateway as I was told this would be better as we have multiple users that may need to create reports and conncet to data sources in future. I'm now wondering if i need to have the personal mode of the gateway to allow access to retrieve data from a folder that is located on a local server...???
Any advice would be appreciated, thanks in advance.
After doing some further research of my own, I found out that I needed to download the gateway onto the server directly however after downloading the on-premise (enterprise) gateway onto the server I still had the same problem as before, i.e. cannot find folder path.
So after no luck with that I downloaded the personal mode of the gateway onto the server and created a server power bi user and this has worked. This is not ideal as we are a company that needs the collaborative ability that comes with the on-premise (enterprise) gateway but I can't find any answers to this issue so until I do it will have to do.
Hi @Mike_Sims ,
Based on my research, you may check with your user name and password and you could refer to below links that may help for you:
Regards,
Daniel He
I have restarted the gateway connection as per the recommendations and the error is still coming up. Im also pretty sure my credentials are right.
I have attached a screen shot of the error details:
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |