Load excel and remove reference

[Anonymous]

Hi

I've stumbled in something fairly simple. I want to load in pBI data from an Excel file. However it's a "one off", I don't want to refresh it. I know you can unflag the "refresh this table" when doing refresh, but that's not the issue. THe issue is that when I load to powerbi service this dataset that contains a connection to a db (which works with the gateway) and the "link" to this (local) excel, the gateway says that it's not configured correctly beacuse it can't (of course) reach my local file. But I don't want it. I want to load the data and then forget about the file...

Isn't it possible?

[v-frfei-msft]

Hi @Anonymous,

As @Stachu said, you can enter the data directly to work on it. Also I suggest your to upload the file to sharepoint or one drive, then you can get the excel file from sharepoint or one drive in Power BI desktop to work around.

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[Anonymous]

Hi

thanks for your answers. I don't believe that these are solutions as they're workaround. I can't load it on sharepoint as it's a file used often in the organization on a shared google drive folder and enter data is not the best solution as it's big amount of data. It's a pretty weird behaviour to be honest.

[Stachu]

if the file is small you can use Enter Data in the query editor and just paste your end result there - it creates a JSON equivalent of the table without any references