Forum Discussion
Best set-up: dataflow, dataset and report
Hi sc4ry
"Am I still right, that measures and relationships can be build only in Desktop?" Yes
"Should I connect all dataflows again to one big dataset, to manage measures and relationships centrally?" Yes, Once you set up your Dataflow(ETL from all sources) in the service, you will import it to your desktop to build your Model(Dataset) and then publish it.
"Or do I miss any possibility in the PBI Service, to handle measures and relationships directly here?" No, you can't add or manage measures nor relationships in the service. All done in the desktop.
Note: to refresh your report in the service you first need to refresh the Dataflow after that you can refresh the Dataset to see the visuals of the report being refreshsed.
Hi sc4ry
"Am I still right, that measures and relationships can be build only in Desktop?" Yes
"Should I connect all dataflows again to one big dataset, to manage measures and relationships centrally?" Yes, Once you set up your Dataflow(ETL from all sources) in the service, you will import it to your desktop to build your Model(Dataset) and then publish it.
"Or do I miss any possibility in the PBI Service, to handle measures and relationships directly here?" No, you can't add or manage measures nor relationships in the service. All done in the desktop.
Note: to refresh your report in the service you first need to refresh the Dataflow after that you can refresh the Dataset to see the visuals of the report being refreshsed.
Dear aj1973 ,
thanks a lot, that helps already a lot. Meanwhile I created some dataflows (Calendar, some dimensions and one data table). When I now want to access these via Power BI Desktop, I am getting the following error:
DataflowsStorageAccountKeyRetrievalForbidden: DataflowsStorageAccountKeyRetrievalForbidden
Details:
Error=DataflowsStorageAccountKeyRetrievalForbidden
Azure connections (preview) is enabled. Is there anything else I can do as a Workspace Owner or do I need to get in touch with our IT as overall admin?
sc4ry sorry didn't understand your request! You said some dataflows! It should be multiple sources, one dataflow and one dataset.
Also you said you don't want to access this via desktop...what are you talking about?
Your issue is no longer clear to me.
Hi,
sorry, maybe also due to a spelling mistake of "not" and "now". One of the advantages I saw was, to have multiple datasets, based on the data. So I will not mix all different data sources together in one dataflow, as I am building a Dashboard with different HR data (FTE, Learning, Recruitment, etc).
To build the reports, I now need to connect the dataflow(s) to Power BI Desktop, but when I do so, I am getting the above shown error.
Yes it is a good idea not to mix...
Know that Dataflows are stored in Azure data lake, so yes in order to access it from your desktop you would need permission. Ask your Azure Admin for it.
Good luck