Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Load excel and remove reference

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?

4 REPLIES 4
v-frfei-msft
Community Support
Community Support

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @Anonymous,

 

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


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

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
Community Champion
Community Champion

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.