Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Gateway Clusters connecting excel file

Hi,  Im trying to connect excel for gateway.  but no luck with that.  I dont know isuue is full path or windows username. for user name I tried and  .Still no luck. Is t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    After the struggling from hours I figured out we can find windowa user name from the command whoami,
    username will appear like this format :- abcd/username.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, 
Im using standered gateway for the process. 

As you can see on the above image, I think gateway for the DB is success. Only remaining is 2 local files.
I couldnt find the issue.
Do I need to add both personal and standered gateway for continue the process ?


Thank You

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

It seems like your report used multiple types of data sources. For power bi refresh operations, you need to configure all of the data sources that your report used.

If you are working with reports that mixed both on premise and cloudy data source, please turn on the use gateway to handle the cloudy datasource option.

Merge or append on-premises and cloud data sources 

Regards,

Xiaoxin Sheng