How to pull data from a Enterprise gateway server c drive to Power Bi desktop

[lavankumar1989a]

Hi Experts,

Need your help on my requirement that is i have 4 enterprise gateways installed on 4 different windows servers. Now i want to pull data from 4 servers c drive to power BI desktop to create a report for Gateway performance monitoring purpose. I don't want to install Power Bi desktop on server machine as well to achive report.

Thanks for your kind help.

Thanks,

Lavan

[Anmolgan]

What kind of dataset you want to pull from those 4 servers?? you can surely use Dataflows here, but am not sure your requirment falls in for the given connectors in powerbi.

[lavankumar1989a]

@Anmolgan 

Thanks for your quick response. I want to pull gate way logs from all 4 server and build a consolidated report.

Let me know if any details required. 

[Anmolgan]

@lavankumar1989a  You can use Text/CSV connectors if you just want to build reports over the csv files, in your case am not sure if this will work but you can give the below a try and see if that works in your case:

Install On-Premise data gateway on all 4 servers.

connect them using the same powerbi credentials.

create connection for all 4 gateway files using dataflows and try to build the reports.

[lavankumar1989a]

@Anmolgan 

Could you guide me on navigatoins to pull the data and creating dataflows for 4 servers.

Thanks in advance.

[Anmolgan]

@lavankumar1989a I gave you the high level steps, you can look into more Microsoft documentation around PowerBI