Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
According to this post: https://docs.microsoft.com/en-us/business-applications-release-notes/october18/intelligence-platform...
the desired behavior can be set in the report. We had the pbix file set to summarized AND underlying data. However, after spending an hour or more troubleshooting why the underlying option was grayed out, I discovered that upon publishing, the report does not hold this setting. Once published on powerbi.com it defaults to summarized only. Then, I finally discovered the setting on the service and changed it there to include both options and it worked! This euphoria was shortlived; however, as the users then discovered the underlying data is quite different than it was previously. For example, there are fields missing; so now, this does not meet their needs.
On top of this, after an hour or so, I went back to check the settings in trying to address this new issue and the report setting on powerbi.com was set back to summarized data only. What the heck?!?!? How did this happen? I had a user verify the underlying data option was indeed grayed out. I did not change this setting. What is going on Microsoft? Too many bugs in the last couple weeks. I've wasted too much time on issues that are still not resolved and I'm receiving no help with a premier ticket entered over a week ago.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.