Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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
Hi @Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |