Forum Discussion
Can a pbit file be an entity in a dataflow?
Hi. I'm not sure what you are trying to accomplish here. A pbit is a template with visualizations, format, data, etc. It contains a lot of information. DataFlows are only a place for data. You can't save a pbit in dataflow. You can save the pbit in a sharepoint. If you want pre defined entities in dataflows like Calendar Table, you can just copy paste your Power Query code to a blank query source or copy the entity from Desktop->Transform Data (edit queries window) to the dataflow edit queries. That way you can have a dataflow for your usual data. Then connect to that source inside the pbit. That way the pbit in sharepoint contains all the information including the usual tables from your dataflow.
Hope that helps,
Super UserHi. I'm not sure what you are trying to accomplish here. A pbit is a template with visualizations, format, data, etc. It contains a lot of information. DataFlows are only a place for data. You can't save a pbit in dataflow. You can save the pbit in a sharepoint. If you want pre defined entities in dataflows like Calendar Table, you can just copy paste your Power Query code to a blank query source or copy the entity from Desktop->Transform Data (edit queries window) to the dataflow edit queries. That way you can have a dataflow for your usual data. Then connect to that source inside the pbit. That way the pbit in sharepoint contains all the information including the usual tables from your dataflow.
Hope that helps,
Thank you for taking the time to read and respond. I have taken your comments on board as well doing more playing and learning, I can see now how the request above isn't clear with its phraseology & what it's asking.
I have another question now that I'm struggling to resolve, but i'll raise it as a seperate post if needed.
Cheers!