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
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi fbackes

Please give detailed information for analysis,

As Ross73312 suggested, give the more detailed error information.

Which is the dataset? excel file? SQL server database? online or on-premises?

How does it connect to power bi? import ? direct query?

Do you add this datasource to the on-premise gateway? give the correct credential?

 

You could read through this following link to check which scenario you met.

 

https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

 

Best Regards

Maggie

  • fbackes's avatar
    fbackes
    Helper I
    7 years ago

    Many thanks for your answer, Maggie.

     

    Here is some for info:

    The data source is a text file coming from a POS system. The structure of the file is quite complex, as it is not entity related and I have to refer to different data rows to collect all information of an entity. This is done by using calculated columns. The size of the main data file is 150MB and the size of the dataset is 24MB.

     

    The application uses the PBI service and is not on-premise. All the data sources have been given valid credentials. So far, the personal gateway is used.  

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi fbackes

      I'm still confuzed.

      Steps below are what i assume you have done, if i'm wrong, please correct me.

      1. connect to the data source (text file) with Power BI Desktop (Get Date->Text

      2. publish from desktop to Service

      3. add data source to the personal gateway, and configure credentials and schedule refresh setting as below.

      https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

       

      Additionally, please check if you use the lastest version gateway,alse since personal gateway needs to run as a application, please confirm it runs when refresh is going on.

       

      Best Regards

      maggie

      • 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.