Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Problem with the Gateway in Power BI

Dear: Last week, unexpectedly, they let me run all the automatic updates. My published reports have two types of data sources: excel files located on my PC and database tables from a server. I have...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    2 years ago

    Thank you all very much.
    I've already fixed this by changing the location of the files to OneDrive

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

At the same time, in the standard mode gateway, "misconfiguration" appears. If I deploy it:

the connection to the DB is OK but not the connection to excel on my PC

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

... And if I want to "add to gateway"

returns: "Invalid connection credentials" (when on the other gateway it connects perfectly)

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    2 years ago

    ok, on your first screen (personal mode) I can only see MySQL as a source, no local folder.
    For standard gateway there are two sources listed.

    To enable a connection to your lokal maschine you should check access policies from the web into your maschine. Its the same thing you would like to connect to a company`s network folder.
    You have to enable access to this folder (Firewall rules) and provide a qualified server name where network folder is located. Therefore maybe you have to provide the full name of your local maschine. Not just C:\path\....

    Regards