Forum Discussion

lokihkmaru's avatar
lokihkmaru
Regular Visitor
11 years ago
Solved

Power BI 2.0 refresh from dataset not working

For both Azure SQL and on-prem CSV, I cannot get the data refresh to work. Whenever I go to REFRESH NOW for any particular Dataset, the error message is this:   You cannot schedule refresh for this...
  • meysun's avatar
    meysun
    11 years ago

    For the SQL Azure database, did you upload the .pbix file using the Get Data or did you publish it directly from the Power BI Designer. There is a bug in the direct publish. This should be addressed very soon. In the mean time, could you upload the .pbix file using browser get data-> local file and then go to schedule refresh and configure.

mrvachon's avatar
mrvachon
Regular Visitor
11 years ago
Your issue is most likely caused by the CSV data source, does the azure source refresh for you? You'll need use a gateway to refresh your data that might be stored locally.
  • lokihkmaru's avatar
    lokihkmaru
    Regular Visitor
    11 years ago

    I finally got the CSV data source to refresh. I had to first upload the .pbix file to my OneDrive folder. Then connect to it from the powerbi.com site. After that I can setup the Personal Gateway for refresh. It doesn't work if I publish directly with Power BI Desktop.

     

    As for the Azure SQL source, it still doesn't work and displays the error ("...gets data from sources that currently don't support refresh."). I have set it up using the Get Data function in the powerbi.com site. Not sure why this basic feature doesnt' work. The error message isn't helpful either. 

    • meysun's avatar
      meysun
      Icon for Resolver IV rankResolver IV
      11 years ago

      For the SQL Azure database, did you upload the .pbix file using the Get Data or did you publish it directly from the Power BI Designer. There is a bug in the direct publish. This should be addressed very soon. In the mean time, could you upload the .pbix file using browser get data-> local file and then go to schedule refresh and configure.

      • lokihkmaru's avatar
        lokihkmaru
        Regular Visitor
        11 years ago

        Yes, it works now by uploading the .pbix file using the Get Data. So the direct publish is really to root of the problem. Thanks!