Hello,
How can we get PowerApp Dataflows (and or dataverse) to use the same dataset as our PowerBi reports?
TLDR: We already have a PowerBi workflow in place and datasets published to PowerBi.
We don't want to use the Dataverse to duplicate data. Ideally we also don't want to modify our existing workflow.
Somehow we need to use Model-driven or PowerPortal apps and get them to point to power Bi datasets.
This way we don't duplicate data and everything is pointing to the same place.
Further details:
We have a unique situation where we need a PowerApp to be large enough for our staff to see and use for data entry.
This means we can use either a tablet layout on a canvas app (Mobile layout wont work for visibility) or Model-Driven or Portals.
PowerBi has a 5 year old bug that wont allow you to embed a PowerApp if it has a tablet layout, so this rules out canvass apps and leaves us with Model driven or Portals.
The latter will both require dataverse.
It appears that its possible to create a PowerApps dataflow but I can find no way of connecting it to our PowerBi service to access the datasets.
PowerApps does have a connector for PowerBi but this doesnt work as expected.
Our workflow:
Our current workflow consists of three workspaces - Development, Test, and Production.
We have a number of PowerBi dataflows in place (I'm aware PowerApps and PowerBi dataflows are independant of each other).
We build a new PowerBi Report and add tables we require from the dataflow.
We then publish that PowerBi report so we have its dataset on PowerBi.
We then build the final PowerBi report that uses this dataset.
This allows different members of staff to work on the report/visual elements and another member of staff to work on the dataset side.
Many Thanks,
J
