Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Disapointendin Hybrid dataset and Modelling

Hello,

I'm quite disapointed in the PBI Streaming Dataset with Historical Data. It's possibilities are superb, but the lack of any modelling makes it quite unusable. For example it hou have a datetime field, no way to determine a hierarchy. It doesn't build one itself, but even if we would create it in de dataset, no way to define a hierarchy.

Surely on streaming datasets it would be handy to have some logic as for example yesterdat, since-last week. All quite good possible with some calculated columns ...

I understand that with live connection you have to respect the source logic, but here the source is a native PowerBI Source, so at least some options could have been added.

 

I hope that I'm completely wrong with my conclusing and that there are options, would be very glad to hear them.

General Comment
Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Currently, Real-time streaming data doesn't support modeling data in Power BI Service.

    When connecting to a Power BI Service Dataset with Power BI Desktop, it is live connection which have many limits in modeling.

    Power BI – Live connection vs. Import, comparison and limitations

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I know the limitations, we always use or live Azure-DWH of Azure-AAS, but as the Datasat is a PowerBI dataset there should at least be some small modeling option on server side then.

      My point is, wonderfull technique, but missing some maturity to my point of view.

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi 

        What you are seeking for should be concerned though there is no such features in Power BI currently.

        You could submit an idea here to make it possible in future.

         

        In addition, when creating a dataflow to use our datasource, we can use Power Query online to transform and shape data.

        https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.