Add data source locally to allow refresh?

[Anonymous]

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 from scheduling refresh.

I want to use this local Excel file which will remain static, never updated, to my power Power BI report so that it does not affect refresh. I do not want to have this source added to the gateway, if it is possible to avoid doing so. 

I tried to copy/paste the contents, but Power BI advised it can only take 3000 rows at a time, and to split my data into tables of 3000 or less rows. The file has over 40,000 rows and I do not want to do that, if possible. 

Can I add data from an Excel file, and then save it to the memory of this Power BI Report, so that the data source is no longer a problem?

[vojtechsima]

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]

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 · Accepted solution]

@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]

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]

Yeah.