Forum Discussion

fbackes's avatar
fbackes
Helper I
7 years ago

Refresh causes unknown error

Hi all,   I need some help, because the refresh of one of our datasets permanently leads to an unknown error. The dataset can be processed and refreshed in PBI Desktop without any problems. How ...
Need Help
fbackes's avatar
fbackes
Helper I
7 years ago

Hi v-juanli-msft,

 

yes, I've done exactly what you have outlined.

However, there is one slight difference: The data source is not a dedicated text file, but a directory. The file name can change, so I set up a directory as the data source. It is guaranteed by the overall processing (power shell scrips) that this directory contains only a single file. I think this setup wouldn't make any difference compared to having a dedicated file as the data source.

I've published the dataset from PBI desktop, added the data source and configured credentials and scheduled refresh. I also tried a manual refresh. I even updated to the newest version of the gateway last week. The user under which the personal gateway is running is always logged in and there are no problems with refreshing other datasets using the same gateway. 

The refresh starts and after some time (ca. 30 minutes) the error occurs. 

  • fbackes's avatar
    fbackes
    Helper I
    7 years ago

    Hi v-juanli-msft,

     

    thanks a lot for your message.

    I'm definitely not accessing any AD. The only two data sources are a flat file and an Excel file.

    I'm getting more and more refresh errors with other data sets now too. We even upgraded the VM (10 kernels and 48GB RAM now).

    The logic of the processes is quite complex, but all data sets can be successfully processed with PBI Desktop.