I am being a bit selfish with the exam questions, as I am preparing for them myself and this is the only way I can motivate myself to do it . Win-win ;) /Ruth
Thanks for this usefull functionnality ! it's a huge step made by PowerBI even it's need several skills for an end user, but it's answering a very old need ! I hope they will manage to simplify it in the future. Thanks again for your astonishing work !
1. Count subscribers in current year: COUNT(Subscriber[SubscriberID]) 2. Count subscribers in previous year: CALCULATE(COUNT(Subscriber[SubscriberID]),PREVIOUSYEAR('Date'[Date])) - calculate works with Expression and Filter, which is PREVIOUSYEAR. It requires a single argument - date 3. Add 5% (not 6% as in your formula) - which results in final formula: Goal =CALCULATE(COUNT(Subscriber[SubscriberID]),PREVIOUSYEAR('Date'[Date]))*1.05 P.S. Great video on showing PowerApps capabilities
Thanks. I have two questions: How would refresh of app work in power bi service And If I make changes in power app and publish later, would those changes reflect in powerbi service?
Veeeery interesting!!! Let;s say I am trying to do smth similar retrieving data from SQL Server but instead of creating a new table in Sharepoint, I want to be able to replace the values in the SQL Server through Power BI Service... any ideas? :/
Good tutorial, If I understood correctly it's possible edit fields from tables that come from Sharepoint List. Is there a way to change also fields from the Supplier table (location, supplier, etc...)?
I agree with Alex. Calculate, Count, Previous. Count how many ID are from the result of the calculation of the previous year. But should multiply by 1.05 question said 5% not 6%. There is an error in the formula.
Great video. I have a question on access right. If the report is posted to BI Service for other users, do I need to do more to allow them to have access to sharepoint site ? Any other permission we need to give ? Thanks
Hi Ruth,Thank you for sharing! clear and awesome video as usual!! Do you have idea on how to export BI service report which with embedded Powerapps , and import it to BI desktop report? Cuz normally a BI service report needs to be updated from BI desktop report , and unfortunately since Nov. the new version of BI desktop have trouble supporting building or choosing an existing app to embed (have reported this issue to MS). That's why I'm trying to build the embedded powerapps in BI service..but now don't see a way to import it back to BI desktop, any advice is appreciated!!
for such slight changes Enter data option and subsequent transformation would be much more convenient way of doing this. It would suit if there would be no limitations with row import to PowerApps, are there any for sharepoint lists? I believe this enter data option should be expanded for more user friendly feature in Power BI
Thank you for sharing this great tip. I'm new to PowerApps but need to write back to a Sql Table. I just got the powerapps free version to test this, but I can't see the "+" button as well as the "pen" (edit) button. Is it because I don't have the paid version? Thank you again
Not sure what the restrictions are for the free license. Here is a video on how to work with sql as a source: m.ua-cam.com/video/193b7T_p35M/v-deo.html If you follow the steps and you still dont get the icons, contact the power apps community. /Ruth
once we integrate the apps with bi and published to cloud service, can we make the changes in power bi service and refresh the data to make the changes?
Hi we add comments instead of discount? Can it be done on the published reports ? I am a controller and when ask accountant so same comments I need to published to my boss
Great video. Thanks. Just a small doubt. As far as I understood, PowerApps needs extra license, doesn’t it? I mean, it is not included on PowerBI license, isn’t it? That’s what IT told me when I asked them to use PowerApps. Thanks.
Dear Ruth (and anyone else that might be able to help). Thank you for this great video! We have created a PowerApps where the users of the Dashboard can insert data that should appear in a column in our table visual. For some reason, a lot of the inputs are not showing up in the table, even when we refresh the dashboard and publish manually. The data appears in the SharePoint and in the PowerApps, but not in the table. Do you know what can be the reason for this? Thank you!
Answer to Q14 = #4, #2 & #6. In that order... Re: Write-back: After you publish the report, would the updated data in SharePoint be reflected immediately after an entry is made via the PowerApp visual or only when the dataset is refreshed (either on schedule or triggered manually)? 🤔 Thanks, Ruth!
Hello Ruth, thank you so much for this video. i truly appreciate you. 1. I used this measure just as you showed us in the video but i am not getting back the values for when salesplanupdate is blank. can you please take or look or suggest what might be wrong New Sales = VAR UpdatedSales = SELECTEDVALUE(Sales[SalesPlanUpdated]) RETURN IF(ISBLANK(UpdatedSales), SELECTEDVALUE('Fact - Sales & Units'[Sales Plan]), UpdatedSales) parameters to change the discounts and other columns on the table. 2. Do you have a video that shows how to create a parameter that will change that individual column 3. Is it possible that when I make a change on the sales column it affects my YoY% and W/W% I will appreciate your prompt response. thank you
re :Question 13. I have created a paginated report that is connected to a dataset with RLS rules. When publish to the service you can get the embed token with no additions and put it in your report. the beauty of this is that user when open the paginated reports will only see their data.
Great video! Using this to enable dynamic comments writeback for one my clients report dashboards. I am facing an issue when trying to publish to the same workspace I usually use. I'm certain the issue is now this SharePoint integration, but I'm not sure the work around. The error message I'm getting reads "An error occurred while attempting to publish 'name.pbix': Publishing failed for an unknown reason. (PowerBINotAuthorizedException) Help?
Hi Ruth, If you were to have users interact with the report in the service, how would you be able to set up a report refresh to trigger whenever the Sharepoint List changed? Is there any way to do this without making a composit model and connecting to sharepoint live?
@Casey and Ruth, you could use powerapps to refresh the dataset after an entry in powerapps. But depending on the data size and license plan and frequency usage of the app this might be undesirable
how to make it automatically detect the row ID and system time and datae and user email. I just want them to add comemnts and they cant edit the date time, email or row ID?
and how to make it looks nicer ? I know your video mainly focus on how to bring it to work. Now outside the video, is it possible to point us to where to make it looks nicer or pls make a video on it :-) Thanks a million ^^
Dear Ruth, I just followed your way and am able to edit, add new record and can refresh to see new result in PBI DESKTOP. Then I published it to PBI Service as report. I can update the PowerApp data on this report with the [Powerapp Visual] on the report but then when I select 3 dots on Report and click Refresh , my table visual does not update with the new value I edited. I then goto PBI Workspace, then select the DataSet and click refresh. It goes to [Refresh failed due to gateway configuration issues]. But my SP is online and I can see the SP list has been updated and I have access to it and I do not use on-Prem data. Please help. What am I missing here ? Thanks
Just love your excitement and enthusiasm around this! It was also super helpful, thank you for the effort.
This is so great Ruth!, thank you. Also thanks for the new section of the DA-100, u have a big heart!!!
I am being a bit selfish with the exam questions, as I am preparing for them myself and this is the only way I can motivate myself to do it . Win-win ;)
/Ruth
Thanks for this usefull functionnality ! it's a huge step made by PowerBI even it's need several skills for an end user, but it's answering a very old need ! I hope they will manage to simplify it in the future. Thanks again for your astonishing work !
Thanks 😊!!
/Ruth
Thanks Curbal for making this mammoth task so easy for all of us!
Absolutely great video!! I followed it step by step and it worked.
Fantastic
1. Count subscribers in current year: COUNT(Subscriber[SubscriberID])
2. Count subscribers in previous year: CALCULATE(COUNT(Subscriber[SubscriberID]),PREVIOUSYEAR('Date'[Date])) - calculate works with Expression and Filter, which is PREVIOUSYEAR. It requires a single argument - date
3. Add 5% (not 6% as in your formula) - which results in final formula: Goal =CALCULATE(COUNT(Subscriber[SubscriberID]),PREVIOUSYEAR('Date'[Date]))*1.05
P.S. Great video on showing PowerApps capabilities
😂 You guys always catch up my mistakes, thanks!
You should be power bi CEO. Great videos
😊
Excellent, Thank you. what a great video you made.
Good job.
Exactly I was looking for. Thankyou so much for this ❤️
Thank you very much ! Your courses are very Helpful !
Thanks. I have two questions:
How would refresh of app work in power bi service
And
If I make changes in power app and publish later, would those changes reflect in powerbi service?
Thank you Ruth!. I really love this kind of solutions!!!
Veeeery interesting!!! Let;s say I am trying to do smth similar retrieving data from SQL Server but instead of creating a new table in Sharepoint, I want to be able to replace the values in the SQL Server through Power BI Service... any ideas? :/
Good tutorial, If I understood correctly it's possible edit fields from tables that come from Sharepoint List. Is there a way to change also fields from the Supplier table (location, supplier, etc...)?
Hi Ruth, you will still need source data write privileges, else it would not run.
Perfect topic and explanation. Appreciate
Thanks for the solution, i needed this very much...
Glad it worked!
I agree with Alex. Calculate, Count, Previous.
Count how many ID are from the result of the calculation of the previous year. But should multiply by 1.05 question said 5% not 6%. There is an error in the formula.
Ooops, my bad again...
/Ruth
Goal was to write back, calculation was not the goal, don't be like John
Great explanation Ruth!!
Thanks:)
Great video. I have a question on access right. If the report is posted to BI Service for other users, do I need to do more to allow them to have access to sharepoint site ? Any other permission we need to give ? Thanks
Hope this will help:
powerusers.microsoft.com/t5/Building-Power-Apps/Powerapps-and-Sharepoint-Online-Permissions/td-p/138367
/Ruth
Thank you for sharing it.
Hi Ruth,Thank you for sharing! clear and awesome video as usual!! Do you have idea on how to export BI service report which with embedded Powerapps , and import it to BI desktop report? Cuz normally a BI service report needs to be updated from BI desktop report , and unfortunately since Nov. the new version of BI desktop have trouble supporting building or choosing an existing app to embed (have reported this issue to MS). That's why I'm trying to build the embedded powerapps in BI service..but now don't see a way to import it back to BI desktop, any advice is appreciated!!
Thanks for sharing. Very interesting!
My pleasure 😇
for such slight changes Enter data option and subsequent transformation would be much more convenient way of doing this. It would suit if there would be no limitations with row import to PowerApps, are there any for sharepoint lists? I believe this enter data option should be expanded for more user friendly feature in Power BI
Enter data is only available for the desktop.
Thank you for sharing this great tip. I'm new to PowerApps but need to write back to a Sql Table. I just got the powerapps free version to test this, but I can't see the "+" button as well as the "pen" (edit) button. Is it because I don't have the paid version?
Thank you again
Not sure what the restrictions are for the free license. Here is a video on how to work with sql as a source:
m.ua-cam.com/video/193b7T_p35M/v-deo.html
If you follow the steps and you still dont get the icons, contact the power apps community.
/Ruth
Excellent
once we integrate the apps with bi and published to cloud service, can we make the changes in power bi service and refresh the data to make the changes?
Love this! Really cool
Hi we add comments instead of discount? Can it be done on the published reports ?
I am a controller and when ask accountant so same comments I need to published to my boss
Great video. Thanks. Just a small doubt. As far as I understood, PowerApps needs extra license, doesn’t it? I mean, it is not included on PowerBI license, isn’t it? That’s what IT told me when I asked them to use PowerApps. Thanks.
There is a license included in o365 or at least there was... check it out!
Curbal thanks. They told me it is a different o365 license (and more expensive 🙁). I’ll double check just in case. Thanks.
Maybe this helps:
docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus
/Ruth
@@CurbalEN My IT also told me similar thing. I achieved it using Trial version. Although my organisation have Sharepoint available Powerapps was not
12:34 Good video. Didn't know that apps allows that. 👍
You were the winner!! Contrats ! :)
Dear Ruth (and anyone else that might be able to help). Thank you for this great video! We have created a PowerApps where the users of the Dashboard can insert data that should appear in a column in our table visual. For some reason, a lot of the inputs are not showing up in the table, even when we refresh the dashboard and publish manually. The data appears in the SharePoint and in the PowerApps, but not in the table. Do you know what can be the reason for this? Thank you!
Hi there! did you ever find a solution to this issue? Dealing with the same problem now.
Answer to Q14 = #4, #2 & #6. In that order...
Re: Write-back: After you publish the report, would the updated data in SharePoint be reflected immediately after an entry is made via the PowerApp visual or only when the dataset is refreshed (either on schedule or triggered manually)? 🤔 Thanks, Ruth!
Manually I am afraid. I think the automatic refresh works only on direct query, but I can be wrong...
/Ruth
Agree with Alex
Hello Ruth, thank you so much for this video. i truly appreciate you.
1. I used this measure just as you showed us in the video but i am not getting back the values for when salesplanupdate is blank. can you please take or look or suggest what might be wrong
New Sales =
VAR UpdatedSales = SELECTEDVALUE(Sales[SalesPlanUpdated])
RETURN
IF(ISBLANK(UpdatedSales),
SELECTEDVALUE('Fact - Sales & Units'[Sales Plan]), UpdatedSales)
parameters to change the discounts and other columns on the table.
2. Do you have a video that shows how to create a parameter that will change that individual column
3. Is it possible that when I make a change on the sales column it affects my YoY% and W/W%
I will appreciate your prompt response. thank you
I figured out No.1 Using the coalesce function. Thank you. I still need help with 2. and 3.
Good stuff!!!!
re :Question 13. I have created a paginated report that is connected to a dataset with RLS rules. When publish to the service you can get the embed token with no additions and put it in your report. the beauty of this is that user when open the paginated reports will only see their data.
Can you please share the app you created?
Genial! Es posible recrear algo parecido sin tener acceso a share drive? Nosotros usamos OneDrive :(
To be able to write back, users need to have write permission to the source, so a shared drive/storage or database is needed
Great video! Using this to enable dynamic comments writeback for one my clients report dashboards. I am facing an issue when trying to publish to the same workspace I usually use. I'm certain the issue is now this SharePoint integration, but I'm not sure the work around. The error message I'm getting reads "An error occurred while attempting to publish 'name.pbix': Publishing failed for an unknown reason. (PowerBINotAuthorizedException) Help?
Hi Ruth,
If you were to have users interact with the report in the service, how would you be able to set up a report refresh to trigger whenever the Sharepoint List changed? Is there any way to do this without making a composit model and connecting to sharepoint live?
I think automatic refresh from powerapps to power bi works only on direct queries, but I can be wrong...
/Ruth
@Casey and Ruth, you could use powerapps to refresh the dataset after an entry in powerapps. But depending on the data size and license plan and frequency usage of the app this might be undesirable
1. calculate
2. Count
3. Previousyear
Thanks!
Appreciated
Is there Any Options in power BI, display reports with slideshow ??..If u have any idea pls share☺️
This one:
m.ua-cam.com/video/Jz6i1X5JOco/v-deo.html
/Ruth
Hi Ruth, Do I can make the same with OneDrive?
I think so...
how to make it automatically detect the row ID and system time and datae and user email. I just want them to add comemnts and they cant edit the date time, email or row ID?
I am not able to find power app to be added in power bi. Not available in the marketplace.
and how to make it looks nicer ? I know your video mainly focus on how to bring it to work. Now outside the video, is it possible to point us to where to make it looks nicer or pls make a video on it :-) Thanks a million ^^
There are themes in power apps, you can try those ;)
In the New Discount Measure instead of if, you could have used the new Koala (coalesce) function .. :)
Dang! You are right! How did I miss that? Hard to get new habits in , but thanks for the reminder :)
/Ruth
This Worked for me. Thank you
How to give access to external users to input data to the power app??
What about using Parameters? isn't it the same as using Power Apps to input?
You would have to create one parameter per row to get the same result.
/Ruth
14:00 Thanks ❤️
4,2,6
I cant see anything visible in the "Edit fields"
1. Calculate
2. Count
3. ParallelPeriod
Got it!
Dear Ruth, I just followed your way and am able to edit, add new record and can refresh to see new result in PBI DESKTOP. Then I published it to PBI Service as report. I can update the PowerApp data on this report with the [Powerapp Visual] on the report but then when I select 3 dots on Report and click Refresh , my table visual does not update with the new value I edited. I then goto PBI Workspace, then select the DataSet and click refresh. It goes to [Refresh failed due to gateway configuration issues]. But my SP is online and I can see the SP list has been updated and I have access to it and I do not use on-Prem data. Please help. What am I missing here ? Thanks
No no no. It's not good in Power BI service, because of refresh issues.
Goal = CALCULATE(COUNT(Subscriber[SubscriberID]),PREVIOUSYEAR(Date[Date]))*1.05
Got it:)
CALCULATE, COUNT, PREVIOUS YEAR
Noted :)
4, 2, 6