Power BI Service, Edit report and Add in PowerApps Visual
- 2nd January 2020
- Debbie Edwards
Following on from our blog PowerApps in Power BI...
On the report created previously, you want to update Click Edit Report
The Power App visual will now be available in Visualisations because it was added in the desktop file
Add the Power App in power BI service
In order to test out the new service I’m adding in a blank page
Click on the power App visual and add it to the new blank page
I want to add the CustID and the Date from the worst served new staging table
Then I can choose App rather than create new because I have already published an App
I'm choosing my Worst served App and click Add
I've clicked go to power Apps Studio which opens the PowerApp in Studio and you also have the powerApp in Power BI Service
The very first issue I have is a formatting issue. My Power App is Tiny and unreadable. Time to go back to the power App Studio and change the Settings
App Settings – changing the App to Default size 16.9. For the time being I'm not going to think about making the app look good. I just want to be able to see the text on the power BI page
- Save and publish the PowerApp
- Go back to the Power BI service
Power BI service
I had to delete and readd the PowerApp to get it to refresh.
Its also worth noting that if you dont create your visual to the right size before adding your App, the App will have scroll bars etc and you cant change the size of the PowerApp, only the size of the visual that holds it
The Power App doesn’t look great but it will do to test.
First of all we want to see if it works so add a table with the Worst served Data items
Add a CustID and click Update
It works. Now delete the item just added. Again it works. This is part one done. Part 2 is that we want it to update worst served Customers from the customers table
How do the Updates Affect the pbix file?
Click Save in Power BI service and go back to the Power BI Desktop file
The new visuals aren’t there. This is as expected because they were not created in Desktop.
Imagine that you have created your Power BI App Visual and you still have a list of updates, changes and bug fixes that you want to do within Power BI Desktop
If you update and republish you lose the PowerApp Visual
Currently, this options is only viable if the PowerApp is the very last thing you do and you don’t need to update the pbix file at all.
As a consequence I don’t think that Editing your reports within Power BI Service is a good idea.
having chatted to a few people on the forums, Editing reports in service is normally done when you need something quick and you intend to go back and update the pbix file with the amendment.
What happens when you add the PowerApp in Desktop
In Desktop Add the PowerApp and the table to check its working. Then Publish into the Service.
Note the change in how it works. If you Update or Delete, the table doesn’t change until you Click Refresh. If you add it in Service you don’t need to click refresh.
For the time being I’m going to accept this as it’s the only way to move forward and keep working with the pbix file.
I have created an idea on the power BI forum to deal with this issue https://community.powerbi.com/t5/Issues/PowerApp-with-DirectQuery-Mode-Need-to-be-able-to-have-correct/idi-p/791690#M48425
Omitting Worst Served Customers using the new Filter
I have Customer 1000000 and 1000001 in my Direct Query table and they have both been removed from the report
Great, I now have a Power App that can be used to omit records in a report without straight away.
There are some issues to be ironed out but this really opens up what you can do with Power BI.
If this guide was useful, and you feel you would benefit from further training, our Power BI Training Course can help you develop your practical knowledge and skillset.
If your organisation would like more information on Power BI and how to get started download our quickstart PDF below, designed to provide you with relevant actionable dashboards and the internal skillset to use them, or call us on 01246389000 or email us on firstname.lastname@example.org to discuss the opportunities Power BI and Azure can create for your business.