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.

Tsanka's avatar
Tsanka
Icon for Kudo Collector rankKudo Collector
11 years ago

I had similar problems that were due to transformation made in the query. The transformations were of type   

 

#"Replaced Value" = Table.ReplaceValue(#"Changed Type","1","01",Replacer.ReplaceValue,{"Month"})

 

In the PowerBI Desktop the query was extracted, transformed and loaded successfully. When I tried to refresh the dataset from the service, I received similar errors as yours. Removing the transformations solved the issue.

 

Hope this helps.

lokihkmaru's avatar
lokihkmaru
Regular Visitor
11 years ago

I haven't made any transformations yet. I am simply displaying the raw data in a table to test the refresh feature.