Excel and Power BI – better together
Great new feature (preview) is introduced in Apr update of Power BI Desktop. Now we may connect directly to the dataset published in the Power BI service. Other words – create and support the data model in Excel, and generate visualization in Power BI Desktop connected to such model. Exactly the way I prefer to do.Congratulations to our new and renewed MVP's
Let me congratulate the following MVP"s. They really are what makes our community so strong and fibrant. If you like to learn more about our MVP program and what it takes to become one, see mvp.microsoft.com During the first 3 months of 2017 we have added 2 new MVP's. Gerardo Zuccalà Kenneth Barber Segundo Miguéns Romeu We have also renwed the following MVP's. Congratulations on your renewal and thank you for all the great contributions. Aki Ebisawa (海老澤 亜希) Boriana Plamenova Petrova Herve Thiriez Ingeborg Hawighorst Jinjia Xi (郗金甲) Liam Bastick LiMing Fa Mike Girvin Mourad Louha Purnachandra R Duggirala Tony Christopher De Jonker Toru Tanaka Victor Roman Castro Yolanda CuestaHybrid model refresh - it's worth to read the documentation
That's not the question, just to share my experience if it'll be useful for someone. I had Excel data model published on Power BI with two queries (actually much more, but these two are in questions) - Q1 which pick-ups data from on-premises SQL server, and Q2 which takes the data from Excel file published on SPO At the end of first one it was like =Table.Combine(Source, Q2), other words query to on-premises data and right after the to cloud one. It worked fine before Dec previous year. After that manual refresh worked, schedule one failed to refresh. More detailed investigation shows what oAuth2 request token (SPO) works fine (by default lives an hour), but ADFS refuses to give refresh token. Finally I found this article https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshooting-power-bi-personal-gateway/ which explains the bug in Power BI services. The solution was to extract Q2 from Q1, i.e. Q1 takes only on-premises data, Q2 only cloud one, and new Q3 which appends Q1 to Q2 gives the result. With such separation scheduled refresh works."Never use your mouse" -- but I'm faster!
I saw this thread on Reddit, and I thought I'd ask the community here. Are you faster with Excel using keyboard shortcuts or using your mouse? Which do you prefer, or do you use both? https://www.reddit.com/r/excel/comments/a7dji5/never_use_your_mouse_but_im_faster/
