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.

     
vojtechsima's avatar
vojtechsima
Super User
3 years ago

Hi, Anonymous ,
you can keep the same folder path and put it to the server where you run the on premise gateway and connect it like that. OR you can put it on Sharepoint.

However, you cannot use your local files in powerbi service, you can like split your file to X rows and manually add it to power bi through ENTER DATA,
there and then append it if you really want to avoid the onpremise/sharepoint solution.

 
  • 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