Connect dataset to data source not giving me option to select data source

[nleuck_101]

Hello All,

I created a data source from an Excel file in Sharepoint but when I try to connect to the Gateway connection but it doesn't allow me to select a Maps to: It says Add to gateway but I've already created the data source in the gateway. Anyone have a step by step process on step up a data source and connect the dataset to the data source?

Thanks!

[nleuck_101 · Accepted solution]

@GilbertQ

Thank you for your response. I was able to figure out my issue. The URL in the Power BI desktop file was slightly different than the data source URL. Once I fixed that I was able to connect the dataset to the gateway.

[GilbertQ]

HI @nleuck_101 

This should help you get it working

Loading Excel Files from Sharepoint - (powerbi.tips)