Forum Discussion

Rate's avatar
Rate
Icon for Helper III rankHelper III
6 years ago
Solved

Datasources on Desktop Report not showing in Data Gateway

Hello!

 

I have uploaded a report with a dataset consisting of various Excel files in different folders (via obtain Data -> Excel).

Also, I have installed a On-Premises Data gateway in a server, where I have configured all the different Excel files as datasources.

 

However, when I try to configure automatic update, in the Data gateway menu, I only see one of the various data sources (image below).

 

I would swear that a few days ago I had all the data sources listed here, but I can't see why this has changed. 

Any ideas?

 

Thanks a lot!

 

 

  • Rate's avatar
    Rate
    6 years ago

    Hello both,

     

    Thank you for your responses. 

    I checked everything you suggested, but that was not the problem. After additional research, I tried deleting the data source and uploading it again, and it seems to be working now.


    Thanks a lot!

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support

    Hi Rate ,

     

    Could you please check if you can see the data source in the "Power BI Desktop" - "Files" - "Options and Settings" - "Data source settings" - "Data source in Current file" after download pbix from Power BI Service? Please also check in Power Query Editor that if the queries you want to use have checked "Enable load" and "Include in report refresh"?

     


    Best regards,

    • Rate's avatar
      Rate
      Icon for Helper III rankHelper III

      Hello both,

       

      Thank you for your responses. 

      I checked everything you suggested, but that was not the problem. After additional research, I tried deleting the data source and uploading it again, and it seems to be working now.


      Thanks a lot!