Difference Between Power Bi Desktop And Power Bi Service
Christian Erdmann
I have an issue with power bi desktop vs power bi service. I have a power bi pro account. I have a report that gets data from API's and sharepoint sites and I display this in both a report and some dashboards.
The refresh on power bi service doesn't show the same results as the refresh on power bi desktop. Except when I publish the report to power bi service it briefly shows the correct data, however it reverts back to the old data. Does anybody have any experience with this or has anybody encountered something similar?
I found out that my dataset loaded the same amount of data (counts of hours per employee in this case) except the first and last documented date had an offset by one (desktop vs. service). I think power bi service and power bi desktop handle the parsing of date differently (european vs us date format or something). I changed all my date parsing and forced a dateformat on it and it seems to work. this was a very frustrating escercise. Thank you so much for your repsonse and thinking along with me!
On Service,did you directly get the data from Sharepoint online?If so,when you make changes on desktop,you need first to make a refresh in Sharepoint online,then make a refresh in Service,as the data in Service is synchronized with the data in Sharepoint online.
Yes. I also realized that there was some visual filters applied in my desktop app, that was not working in PBI service.
Solution: Create a calculated column with filters, and then it works.
Well, a question, what is the difference between Power Bi Desktop & Power Bi Desktop Report Server?
is that I try to open a report that I have made in Power Bi Desktop, and when I open it with Power Bi Desktop RS, I get an error to open the document.
Thank you for your help
to me it looks like the main difference is that Power BI Report Builder is a tool dedicated for authoring paginated reports that you can publish to the Power BI service.
Documentation:
Power BI Report Builder - Power BI Microsoft Docs
Get started with Power BI Desktop - Power BI Microsoft Docs
Today a user reached out to me and said that the Spend information was missing from their report I created. This was created about a year ago or so and this was working fine as of Friday and there have been no updates made to the model or the visuals. The datasets refresh every night and there were no errors and I don't see any other issues with reports connected to this data set.
What I have done to attempt to resolve is refresh the model from desktop and the service, republish the model to the service, refresh the visuals, reset all filters and clear the cache. I'm not sure what else to do to resolve or where the disconnect is between the two? There is no row level security.
Filters and slicer selections are persistent between sessions, regardless of republishing the data. I would look at those. Hover over the Filter icon in the service and see what is filtering that data. On the desktop it is the old funnel icon.
Thanks! I just double checked and the filters are the same between the service and desktop and I don't have any hidden filters currently. I reset all bookmarks as well and still the information is not the same.
Well, it is difficult to know what else is going on, but I assure you, this is not a bug.
Is this in a premium workspace (PPU or Premium Capacity?) - if so, in Power BI Desktop, get the query for the Matrix viz from the Performance Analyzer, then run that query in DAX Studio against the XMLA endpoint for that report. What does it return?
I was't sure if you saw I did update my original message in that I tried publishing my model to another workspace and the information is matching desktop when published to that workspace but still not the other and I had no idea what could be the difference between the two workspaces that would cause this?
However, if you have published to another workspace and it works, then I am 100% sure that either the data in the original workspace isn't refreshed or you have a filter/slicer setting that affecting it.
Ok I see that part and I looked at number two and compared them and still the same, chunk of dates are missing from when I ran the query from the XMLA in the service vs when I run it from the desktop version everything is there.
When I logged in this morning, the one I published to the other workspace refreshed over night and now looks like the one with the missing data, both now still not matching what was published to the workspaces.
Anyway, Microsoft is not doing a good job in marketing the two versions properly. They describe them in pretty much the same way, as if they could do the same, but at the same time it seems like the desktop version is actually less powerfull.
I just installed the desktop version and it seems like it doesn't sync with the cloud version, i.e. it doesn't show there-created flows, which is kind of a bummer. I suspect it won't show flows that were created on desktop in the cloud version, either.
I agree it doesn't seem communicated clearly. From my understanding, Power Automate Desktop does not have the functionality (actions) from cloud based apps (One Drive, etc) and flows cannot be triggered automatically. In order to have a desktop flow triggered you need to download a data gateway. My short experience with Power Automate so far has me working with the cloud based platform more than the desktop version.
I think Power Automate Desktop (PAD) is good for doing things on the local PC. For instance, we have a legacy ERP system that does not have an API. Power Automate Desktop handles interaction with this legacy ERP.
Similarly, PAD is used for automation of workflows that are happening on the local PC (working with files not on the cloud, but on the local PC)
It remains unclear to me as well. The sales team should clarify the differences of PA-Desktop vs PA-OnLine The desktop edit is laid out much better than OnLine. To add to the confusion, the Desktop version seems to also have App connectors that are labeled as "Premium" which may be another tier of pricing for the Desptop. MS Help has been unable to answer the question.
Echoing all these complaints. It seems to me that the biggest problem is the gap between licencing capabilities, and it is not clear what I cannot due just because it is how it is, and what I cannot do because of the limits of my licence.
Cloud is so bad compared to desktop, there is no control whatsover is happening, when Desktop shows what are in variables, where it fails, can make subflows and everything else. Only bad is (in desktop) that in order to automatically trigger a flow, you need pay (premium), but this is Microsoft's fault, not a technical. Cloud tries to help users so lot but if there is no right service, you can not to anything. I tried to follow (Cloud) Youtube examples, but only get 10% of them working, and those are very basic.
I agree, but at the same time, but the biggest challenge with Desktop is, most of the thing are required Premium. Like use of Excel Online which is very common, automatic trigger flow again very useful to have.
It's time for the June Community Newsletter, where we highlight the latest news, product releases, upcoming events, and the amazing work of our outstanding Community members. If you're new to the Community, please make sure to follow the latest News & Announcements and check out the Community on LinkedIn as well! It's the best way to stay up-to-date with all the news from across Microsoft Power Platform and beyond. COMMUNITY HIGHLIGHTS Check out the most active community members of the last month! These hardworking members are posting regularly, answering questions, kudos, and providing top solutions in their communities. We are so thankful for each of you--keep up the great work! If you hope to see your name here next month, follow these awesome community members to see what they do! Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzcreativeopinionExpiscornovusFubarAmikNived_NambiarPstork1OliverRodriguesmmbr1606ManishSolankifernandosilvaragavanrajanBCBuizerExpiscornovusrenatoromaoLucas001timlAlexEncodianViswavEmadBeshaiDBO_DVDeenujiUmiantaChrist0fGochixVishnuReddy1997citron-trucmandelaVishalJhaverieetuRoboJohanTprathyooanandm08VictorIvanidzenicoxrfm1964shashankbhidepaulbeck1 rpaa LATEST NEWSSummer of Solutions 2024The Summer of Solutions challenge kicked off this month - an amazing Microsoft Community initiative to win free tickets to the Power Platform Community Conferencethis September in Las Vegas.The challenge is NOW OPEN to all #PowerPlatform community members and will consist of four weekly entry periods until July 14th, 2024. Click the image below to find out more on how you can win free tickets to #PPCC24 by entering the Summer of Solutions TODAY! Microsoft Customer StoriesWe're constantly working with an array of great businesses across the globe to assist them in taking advantage of the latest business applications technology.If you'd like to find out more about their low code journeys, click the image below to view our playlist of Customer Stories to discover how Accenture, Lumen Technologies, Cineplex, and many more, are streamlining their business processes with Microsoft Power Platform. Microsoft Leap ProgramHave you heard of Microsoft Leap - a global program designed to recruit, develop, and upskill unconventional talent for careers in the tech space.Microsoft Leap organizes a number of pathways into the industry, including the recent "NFL Legend Cohort - Technical Program Management" run jointly with the NFL Player Care Foundation (PCF) who are dedicated to helping retired players improve their quality of life.Click the image below to find out more about the great day shared at the Redmond campus and be sure to visit the Microsoft Leap website to discover how this amazing initiative is helping re-launch the lives of countless individuals.www.leap.microsoft.com UPCOMING EVENTSBiz Apps Partner Summit Seattle July 24-25It's not long now until the Biz Apps Partner Summit, which takes place at the Hilton Bellevue in Seattle on July 24-25, 2024.This event is the perfect place to network, connect, and learn how to scale your Microsoft practice, drive profitable revenue, and dazzle your customers! There's a great selection of speakers, including the likes of Tom Patterson, Donald Kossmann Joseph Corigliano, Cecilia Flombaum, Peter Jensen, John Siefert, Becky Lymberis, Daniel Rippey, and many more.Click the image below to find out more and register today! TechCon365 & Power Platform Conference D.C. August 12-16Things are hotting up for the next TechCon365 & PWRCON Conference in Washington D.C. on August 12-16, 2024.Featuring the likes of Tamara Bredemus, Sunny Eltepu, Lindsay Shelton, Brian Alderman, Daniel Glenn, Julie Turner, Jim Novak, John White, Jason Himmelstein, Luc Labelle, Emily Mancini, MVP, UXMC, Fabian Williams, Emma Wiehe,and many more, this is the perfect event for those that are looking to gain invaluable insights from industry experts.Click the image below to grab your tickets today! Power Platform Community Conference Vegas Sept. 18-20thAre you ready to come and join the fun in Las Vegas this September at PPCC24?This event is the perfect place to connect with fellow business applications enthusiasts and share your knowledge with the worldwide Microsoft Community.Now's your chance to hold all the aces. Just click the image below to find out more and we hope to see you go ALL-IN this September in Las Vegas! For more events, click the image below to visit the Community Days website.
d3342ee215