Forum Discussion

New Member

8 years ago

Solved

On-Premises Gateway problem

Hi, All. I have aproblem with On-Premises Gateway. Installed On-Premises Gateway: OK. Manage Gateway status : OK. Tuned a sourse like file, and choosed 1.xlsx file. ...

Need Help

Anonymous
8 years ago
rigus,

What do you mean that "can't create dataset"? You can connect to the Excel file from Power BI Desktop, create reports in Desktop and publish the report to Power BI Service. Then use the gateway to refresh dataset in Power BI Service.

Regards,
Lydia
Anonymous
8 years ago
rigus,

You can also directly connect to Excel file in Power BI Service via Get Data-> Files entry.

Regards,
Lydia

Anonymous

Not applicable

8 years ago

rigus,

1. Get Excel path, Windows username following the guide in this similar thread.

2. Click “…”(Open menu) of your gateway and select “Add data source”, choose File as Data Source Type, input excel path, windows username and your password.

Regards,
Lydia

rigus

New Member

8 years ago

Thanks, Lydia. I forgot to put picture with settings where I tunned sourse like Excel file.

It's ok.

But I cann't create dataset. How can I do this?

Anonymous
Not applicable
8 years ago
rigus,

What do you mean that "can't create dataset"? You can connect to the Excel file from Power BI Desktop, create reports in Desktop and publish the report to Power BI Service. Then use the gateway to refresh dataset in Power BI Service.

Regards,
Lydia
- rigus
  New Member
  8 years ago
  Super. it's work) Thank so much. Do always I work with desktop app? If I want work only with Excel and Power Bi, What do I need do?
  - Anonymous
    Not applicable
    8 years ago
    rigus,
    
    You can also directly connect to Excel file in Power BI Service via Get Data-> Files entry.
    
    Regards,
    Lydia

Forum Discussion

On-Premises Gateway problem

Related content

On-premises data gateways

Power BI Service on-premises gateway

On-premise date Gateway

On-premises gateway issue

On-premises data gateway Offline