Forum Discussion

rigus's avatar
rigus
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's avatar
    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's avatar
    Anonymous
    8 years ago

    rigus,

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

    Regards,
    Lydia

rigus's avatar
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's avatar
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's avatar
    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's avatar
      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

      • rigus's avatar
        rigus
        New Member
        8 years ago

        Understood. I suppose that enough only settings of gateway.

         

        Thanks a lot.