Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multiple files with same source excel Data gateway

Hi Team,

 

I have 15+ excel files which i need to taken and combine in powerbi report. It was good enough to do in Power Query editor. My question is on setting up data gateway. I am using standard gateway and my files are in onedrive. once gateway connections set i found as many number of excel files in gateway source. I am using with different instance like dev, test, prod and it goes numberous files in manage gateways page. How i  make it single source and how i could eliminate this problem.

 

Thanks

M Logendran