Microsoft Employee
Did you add data source for the excel file in Power BI Service - Manage gateways as below? If there are two data sources in the PBIX file, we need to add both of the sources for the data gateway.
Best Regards,
Herbert
Advocate II
Thank's for your replay.
For the file datasource i'm using a folder (it contains other folders and files).
Everything was working fine until yesterday.
I have many excel files in my reports, does it mean that should add them individually? (it worked with my folder source until yesterday!)
Another information, for the existing reports the planned refresh is still working despite the fact that the EG is disabled.
Thank you again for your help.
Best Regards,
KSABI
- v-haibl-msft
How did you get data from the excel file in Power BI Desktop, through the Folder connector as below? If you're using the latest version of data gateway, could you please also try to restart the gateway?
Best Regards,
Herbert- ksabi
I'm using an excel source.
I tried a folder like your methode and declared the source in my gateway as usual.
Witout the "merge join" it works :
But, when i use a "merge quey", i can't select my EG !!
My gateway is not up to date, is there some modifications on PBI Service?
Best Regards,
Khaled
- bdymit
Resolver II
I ran into the same problem yesterday.
Here is the link to my post, to provide additional information.
Thank you!
