Forum Discussion
Timed Refresh and pivoted columns
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.
Super UserHi Anonymous ,
If your dataset is empty then the error is correct. If you are trying to do a step in M based on the dataset, then the data has to be there for you to be able to manipulate it. If there is no data then most steps won't work (like Replace, Sort, Filter, etc). Those steps require more than column headers to work. Your pivot column is the same process most likely.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Hello,
That was my assumption. I was just hoping I hadn't bumped into a "weird limitation" of the BI Service that prevented me from using pivoted columns in a dataset. I'll just have to publish and refresh during that window of time the first time and then it should work from there on out. My assumption was that it would pick it up on its first refresh, however, chances are there is a step that gets done at the time of publish that needs the data to be present for.
Thank you,