Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ClayGotte
Frequent Visitor

On-premise Gateway Configuration Help!!

Hey guys! 

I have been working on this report for about three weeks and just as I was trying to finish the gateway to wrap this thing up it seems I keep funning into problems I dont know how to fix, im reletivly new to power bi so I may just be making some rookie mistakes. I will have pictures attached below. 

 

 

The jist is I had all my files I pulled from for the report in my downlaods folder, I thought the inital problem was that so i moved all the files to a secure internal hardrive. That didnt seem to fix the problem, When I set up the gateway i know that I set it up to pull from the user drive in my computer not that internal but I chnaged some of the data sources from the user to the internal and that still didnt seem to work. The gateway says it not configured right and has all those red X next to my documents for files I used but when I go into the gatew way settings everything is connected and it set up fine. I dont really know where to go from here. I dont know if i should delete the gateway and make a new one that is sourced to pull from the internal or what. Any help is greatly appreciated!! This is where it say the configuration is faultyThis is where it say the configuration is faultyRed X but if you click add to gateway I have already added it and it still dosent workRed X but if you click add to gateway I have already added it and it still dosent workWhere my gateway is all set up and say everythig is goodWhere my gateway is all set up and say everythig is good

1 ACCEPTED SOLUTION

@ClayGotte Each of those files is a datasource if you connected to each excel file... you would need to add the file as a datasource on the gateway for every one of them that you use in your report. The datasource type "File, Folder, SQL DB" all need to match a datasource you set up in the Enterprise gateway. For that long laundry list of Excel files, it doesn't appear you have those as datasources to connect to. Also, you will need to make sure your user is on the data source (in the gateway) in order for the dataset of the report to recognize that you can use it.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

1 REPLY 1

@ClayGotte Each of those files is a datasource if you connected to each excel file... you would need to add the file as a datasource on the gateway for every one of them that you use in your report. The datasource type "File, Folder, SQL DB" all need to match a datasource you set up in the Enterprise gateway. For that long laundry list of Excel files, it doesn't appear you have those as datasources to connect to. Also, you will need to make sure your user is on the data source (in the gateway) in order for the dataset of the report to recognize that you can use it.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors