Forum Discussion
PowerBI DataSet from Excel (Live Connection) data model
Hi powerdell ,
It is impossible to create a dataflow base on the dataset, but you can refer the workaround in the following thread to do it.
You can not build a dataflow on top of the dataset, you can only do it the other way round.
The easiest way I know to replicate the models is by coping the M script from PBI Desktop advanced editor into dataflows.
You can still reference the same tables in dataflows, you just need to make sure "Enable Load" is not on.
And as I referred in my previous post, if you are connecting to a dataset, the calculated column can't be created. What's the underlying data source of your dataset? It is a excel file which store in Sharepoint site or SQL Analysis Services? And what's the calculated column used for? Later we can check if there is any other method can achieve the same function...
Best Regards
Thanks again...
Ok will try the hack you have provided on the DataFlow, but please forget the Dataset/Dataflow that is just me desperately trying anything to achieve the above stated use case:
- 1. Have refreshing/live connection to a (SharePoint hosted) Excel file
2. Create calculated column (or join/merge data)
3. Use model in PowerBI Report
It cannot be done (out of the box) it seems and that seems incredible right? How can such a basic use case not be supported?
I would be very interested to hear from the community how they would solve this use case? Do I really have to do all modelling and data work in Excel?