Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
File look like this
BUT, I cann't create dataset.
help me, please. How step by step create dataset. Yearsteday I read forum,but only found answer where interface different like me. I guess it depends on the update Gateway .
Thanks for help!!!
Solved! Go to Solution.
@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,
You can also directly connect to Excel file in Power BI Service via Get Data-> Files entry.
Regards,
Lydia
@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
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?
@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
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?
@rigus,
You can also directly connect to Excel file in Power BI Service via Get Data-> Files entry.
Regards,
Lydia
Understood. I suppose that enough only settings of gateway.
Thanks a lot.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
54 | |
27 | |
15 | |
14 | |
13 |