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.
Hello All,
I'm working with the IT dept. to figure this out. What I need to know is if the PowerQuery (M) portions need to take place in the PBI desktop or if I can upload it "as is" with a null dataset that will refresh properly in the service.
Thank you,
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.