Forum Discussion
Helper IIError message in data set power bi online
Hi bvdm1980
You can try the following steps to fix this problem:
Check the data source credentials. Enter the Power BI service. Navigate to the workspace that contains your data set.
Click on the three dots next to the data set (more options) and select Settings. Under data source credentials, ensure that the credentials of the ERP system and Excel files are correctly entered and are up to date.
If your Excel files are stored on a local network or locally, make sure the data gateway is properly configured and running. In data set Settings, check that the correct gateway is selected for the Excel file.
In the dataset Settings, check the refresh history to see if there are any specific error messages.
Reuploading Excel files to the same location may help reset potential problems with file references.
If your Excel files or ERP system data sources use dynamic data sources, refresh issues may arise. Ensure that the data source is static and not dynamically generated.
You can also see if any of the questions listed in the documentation apply to you:
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bvdm1980Hey Anonymous
Thanks for this explanation. I finally found where it goes wrong. Searched before but couldnt find it.
Apparently it says my excel file connection/gateway is offline. And that's probably beacuse its on a network drive rather than in the cloud.
I thought...okay lets move the file to the OneDrive location online, which is always live. But it still gives me that "offline" message. Cant use my credentials for windows/company in Power BI for this file as it keeps saying credentials arent correct (even when i use current windows credentials).
So it doesnt matter for now if i use a local file or an online version, sadly.