Forum Discussion
Helper IBest 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.
Helper IDear 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?
