Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear PBI-Community,
it might be a coincidence, but after changing my (due to inhouse policy) 4 of my 9 report datasets can no longer connect to the gateway. The gateway is not even shown on some of these reports...
funny thing:
aslo small reports with only 4 Excel-Files (EvvSafety) as source cannot be connected, but for big reports (KD) it works??
Infos after hours of trials:
onPremise Gateway downloaded yesterday, installed as new and restartet
Built up all connections from scratch...
=============
THANK YOU VERY MUCH for any hints!
Solved! Go to Solution.
Thank you for your effort.
What kind of resolved the issue for me was, that I manually entered ALL the dataset connection in the gateway. (Was not necessary before - rights were inherited from the top folder...
This made all my datasets work, beside 1.
What was special, that I could read 8 of the 12 files in that folder without any problem (importing via folder-import and filterin out what I need), the other 4 files which I use the exact same M-Queries for (copy paste) could no be read...
Now I just let copy these files twice a day into another folder and everything is fine...
I voted the idea on the forum to improve gateway-connection troubleshooting...
THANKS AGAIN!
If no Gateway is shown for my dataset: is there a way to show the connections it can and cannot establish, in order to find out what still has to be entered on the gateway side?
Thank you!
@alexrobe,
Do mask sensitive data when uploading screenshots.
Do you add all the four Excel data sources of EvvSafety dataset within gateway? Please make sure that the file path and account are same as that you use in Power BI Desktop.
In addition, when using your account to log in the server that running on-premises gateway, are you able to access to the for excel files via the shared folder path?
Regards,
Lydia
I have done it now - and it indeed has resolved the problems on all reports, but 1.
Wondering, if there was anything changed in the Gateway settings by MS or our company, because it worked nicely before Nov 5th,.
Before that I only had the some 8 folder permissions for everything (was inherited for all files in the subfolders). Now I have in total around 25 additional individual file permissions...
But at least it works, THANKS!
Still:
For the 1 report, where the gateway is not showing up: Is there a way to show which data connections can/cannot be established to a gateway? Any other way to identify, which connection is missing?
Thank you!
@alexrobe,
Which report do you refer to when saying report 1? Do you mean KD report?
If so,you would need to manually check if you add all data sources(folder and files) of this report within gateway by comparing with the data sources in Power BI Desktop. There is no other option to identify which connection is missing.
Regards,
Lydia
Thank you for your effort.
What kind of resolved the issue for me was, that I manually entered ALL the dataset connection in the gateway. (Was not necessary before - rights were inherited from the top folder...
This made all my datasets work, beside 1.
What was special, that I could read 8 of the 12 files in that folder without any problem (importing via folder-import and filterin out what I need), the other 4 files which I use the exact same M-Queries for (copy paste) could no be read...
Now I just let copy these files twice a day into another folder and everything is fine...
I voted the idea on the forum to improve gateway-connection troubleshooting...
THANKS AGAIN!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.