User Profile
ACPBI
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Results on Dashboard & Service Don't Match
Lots of complexities here. I believe this is primarily related to the UTC Conversions and how they behave. Also, I was not on the most recent version on the desktop and removed a trial Fabric License to attempt to figure out how to get the service version to match. Still not the same. My service says -train at the end of it. Not sure why. May open a support ticket eventually but moving forward since all passed except colors changing on my kpi's consistently and just turned that feature off entirely for now until I can research the UTC Conversion and dig in more. (The Actual Duration times are accurate between the desktop & service.) Additionally, I added tooltips and they are not behaving consistently either. Fortunately, QA was able to verify and I wasn't the only one seeing it. Thanks for your time on this. Ritaf1983663Views0likes0CommentsRe: Results on Dashboard & Service Don't Match
Ok. I have stepped through all of these. Here is where I'm at... Verify if the Issue is Related to Time or UTC Differences: Yes - this is applicable to my scenario. However, I am seeing the correct timestamp for calculating the duration between batchStart & batchEnd accurately on the Desktop version. It is only when it pushes to the service that the color is off. It appears my batching measures for this card all match the same basic logic used for the other KPI's / Stages. They are all functioning correctly, except batching. (Testing with QA by lowering the thresholds for testing purposes.) Use DAX for Conditional Formatting: I am using a measure in power bi to explicitly handle nowInCST. Check if You're Using the New Card (Preview Feature): No, I am not Delete the Report from the Service and Clear Browser Cache: I did this yesterday, blew away my measures and started from scratch & that seemed to fix it. However, it is happening again. Still, I have recreated the KPI, and started from scratch again to no avail. **That said, you did mention "Sometimes, display issues are caused by caching or inconsistencies between versions. " I set up a test run on the alert for a KPI card a while back and it updated the service to use Fabric's trial version. I've done nothing with it. I didn't actually prefer that it happened...Regardless, I wonder if this is the issue. I've just updated my desktop to the latest but am not sure what to do for the Service and Tech Support said they didn't know either & to reach out to Microsoft as well. Do you have any feedback related to getting my service off the Fabric Trial and matching up the versions? (I'll google also but if anyone reading this knows please feel free to share as able) If None of These Work: Will do ~ thank you for taking the time to help me out. ***Worth mentioning - I also had a version saved from 4:30am that was when it worked fine on both desktop and service. Now it is not. Batching KPI is red on service and green on desktop.683Views0likes0CommentsResults on Dashboard & Service Don't Match
I am running into a similar issue that I did last time. This time I have deleted, republished but no change. Essentially the desktop results are not matching what I see on the service. (snippet below) I have implemented card visuals to act as KPI's. They display the duration in a set stage. The durations themselves are working fine. However, the colors are not, which are based on a formula if >= xtime then red else green basically. On the desktop you see green - all is well. However, it is misleading on the desktop because, despite the time displaying within an acceptable range of time due to scheduling in this scenario, the service is showing red - as if it is not functioning as expected. Here is a link to the other issue I had and I would really apprciate any insight at all on what the issue is that is causing this. Thanks in advance!Solved798Views0likes4CommentsRe: service does not consistently apply filters saved in desktop
Since my earlier post, I removed my buttons (arrows) I had added to get to the next page. My original thought was perhaps I had the bookmark set without the filters in place. I then added a navigational button to take me to the other report page with filters set. Initially all seemed well. However, the issue did pop up again... I really don't understand the big picture here. I just deleted my published version on the service, cleared my cache & republished as if it was new. Thankfully I've not seen the issue again. If anyone has any other notes worth sharing I'm all ears. Marking as solved & Hope this helps someone else!365Views0likes0Commentsservice does not consistently apply filters saved in desktop
I've seen this multiple times now: I update the desktop to use a set of filters on the visual & then save & publish. The initial newly published report appears fine. However, after multiple refreshes in the service it will lose the filters. Has anyone else experienced this and how did you resolve please? Thanks in advance!Solved407Views0likes1CommentRe: Direct Query - SQL - Modeling - Limitations?
Thank you for making time to reply rajendraongole1 I am discussing this with my team. In Crystal Reports we are able to access the data using connection strings. If you can provide any insight into this option please share. Either way, yes, you have been very helpful!3.1KViews0likes0CommentsDirect Query - SQL - Modeling - Limitations?
Hi All, My company and I are new Power BI users and I would like to have someone please confirm limitations in Power BI using Direct Query based on the below scenario please. I have been asked to create a Power BI Report that includes real-time data. This is not possible with Import Mode due to the limitations on refreshes and timespan across all shifts. To accomplish this I am using Direct Query. I am also being asked to pull data from 2 different servers. In SQL these 2 servers do not have a linked server. So, in sql I can not perform a join of any sort on the data that I am being asked to report on in Power BI. In Power BI I have specifically been directed not to use queries but to use the data model only. I created a model that appears to join the tables in Power BI. I have tableA.OrderID joined to tableB.OrderID. I did set it as a OneToOne Relationship. It only provides the option for cross-filter direction "both". Also, 'Assume referential integrity' is grayed out and not an option. My "FROM" table is tableA. It is a new data source with relatively few records. TableB contains years of data. I did read about merging queries here: https://learn.microsoft.com/en-us/power-query/merge-queries-overview My understanding is this is not an option with Direct Query as it would be for Import Mode. When I create visuals in Power BI I am not seeing data restricted to only orders that exist in TableA where the OrderID matches when I attempt to pull in the needed field. I have requested that we either have a linked server added between the servers or that we add the single field value we need to our new data source. I have not received approval yet and am wondering if my understanding on any of this is incorrect and/or if there may be another option. Thanks in advance for any time and feedback!Solved3.3KViews0likes2CommentsRe: Show 0 value on pie chart or donus chart
I struggled with this as well but finally got something that actually looks really good and you wouldn't know it wasn't a donut chart if you didn't know better. To accomplish an atypical representation of a donut chart that is visually appealing, start by creating measures that represent the needed sections. (FakeDonutSection1 = 100/6 or however many sections you need to create) Add them. I then created KPI cards and carefully formatted so they were brought to the front of the appropriate section.. (You'll have to resize and tinker with obviously) To finish I actually added a transparent button over the top to prevent any unexpected issues with users clicking as they would with a normal donut chart. I think that was it...Hope this helps!3.9KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.