Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Timed Refresh and pivoted columns

Hello All,   I'm going to be doing some "trial and error" but only have a short window to test this in and I need your advice. I have a report that I'm trying to publish to the service, the organiz...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello All,

     

    This may be "news" to some, this may not be news to others. However, I have solved my issue and learned more about the power BI service in the process. Please read below for the methodical approach to the fix:

     

    Method to fix:

    Worked with internal IT dept. to remove the security restriction temporarily. With restriction removed, refreshed the dataset and everything worked 100%. Confirmed scheduled refresh will work by refreshing the data in the model in the service.

     

    Likely cause:

    Steps applied in power query need to take place in the desktop with the data present. When the data set is null the data-dependent steps do not take place in the service and only in the desktop.

     

    Best Practices:

    Ensure that the report works perfectly in desktop before uploading to BI Service. Ensure that data-dependent power query steps have data when refreshing to ensure that all steps can be applied.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello, collinq , I have probably the same issue with pivot step in power query, on desktop works but on refresh from PowerBI service gives the error on missing column, one of those that are pivoted. I have set parameters RangeStart and RangeEnd for the incremental refresh policy that are uaed as a last step in power query after pivot step. I don't understand how the Anonymous user on this topic solved the issue. Should I change the parameters RangeStart and Ranve End to point to the same period for which I load the data in PowerBI desktop in order to perform a refresh with PowerBI service?