Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add data source locally to allow refresh?

I have a report built and connected to a database, which my on-premesis gateway is fine with. However, my report also contains one local Excel file that the gateway does not like. It is preventing me...
Need Help
  • vojtechsima's avatar
    vojtechsima
    3 years ago

     

    Anonymous 
    You don'T need Gateway for that,

    you can do it in "Edit Credentials" where you use Ouath2 and use your Org. account.
    Or if you're admin of gateway, you should be able to add new Connection as Sharepoint folder.

     
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hey. Thanks for the reply.

I tried adding this data source from my organization's Sharepoint, but I get the same "error" that the gateway cannot access it.

 

Is there really no way to tell Power BI "Import this data and then keep it in memory, forget the original data source"? 

vojtechsima's avatar
vojtechsima
Super User
3 years ago

 

Anonymous 
You don'T need Gateway for that,

you can do it in "Edit Credentials" where you use Ouath2 and use your Org. account.
Or if you're admin of gateway, you should be able to add new Connection as Sharepoint folder.

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi. I see the options you mentioned. I switched it from Sharepoint to a local file and then added the data from there. Now I should go back and change the data source to Sharepoint for this edit credentials to work, correct? 

     

    Thanks for your reply

    • vojtechsima's avatar
      vojtechsima
      Super User
      3 years ago

      Yeah.