March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
hey first time experienced this kind of problem. I published report on Power BI service and tried to select gateway connection: one for sql server and 3 excel files and each time I choose the correct "Maps to" path and click "Apply" I get the same error message:
I tried with different workspaces. I created new gateway for excel files. But all failed. I've never had similar issue with the same sql server data source or other excel files so I assume sthg is wrong with the excel file dataset I'm using now but not sure what it can be.
Solved! Go to Solution.
@Monika_85 Hi this is a known issue. Power BI team is working on it.
https://powerbi.microsoft.com/en-us/support/
@Monika_85 Hi this is a known issue. Power BI team is working on it.
https://powerbi.microsoft.com/en-us/support/
yes, creating 3 different gateways for each file definately helped
HI @Monika_85 ,
The error message might be right - the gateway itself might not be running. I would first confirm that the gateway is up and running. Then, I would confirm that the Data Source is correct (which it probably is since you were able to select it), but worth checking on. Then, I would confirm that the userid you are using has access to that Data Source in the Gateway setting.
Since you mentioned that it failed in multiple attempts I would think it was permissions or the gateway not working as expected.
You might also want to make sure that the gateway is updated, it could be that your Power BI Desktop is significantly newer than the gateway (although when that happens the error message usually clearly states that the versions are different).
Proud to be a Datanaut!
Private message me for consulting or training needs.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
38 | |
37 | |
33 | |
20 |