Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |