Forum Discussion

PBIX123's avatar
PBIX123
Frequent Visitor
8 years ago
Solved

Unable to reflect updated value in Power BI Service

Hi All! I have a dashboard with that user can set benchmarking. I have a table for list of KPIs in SQL Server. The idea is whenever a user update the value in SQL Server, there is a measure that will...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    PBIX123,

    I am afraid that it is not supported.

    Regards,
    Lydia

PBIX123's avatar
PBIX123
Frequent Visitor
7 years ago

Anonymous Yes, I did. sorry for the late reply!

 

I believe the problem is the SQL Server does not push the data to the data model used in Power BI. Did some research about real time data, and tried with streaming dataset. However, I can only manage create the table that I want to have real time data. I was wondering if current version support to stream dataset for one particular table and maintain the other tables in Azure Analysis Service to refresh only for the set schedule refresh?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PBIX123,

You would need to split the tables into different datasets, one for streaming dataset, and other for schedule refresh.

Regards,
Lydia

  • PBIX123's avatar
    PBIX123
    Frequent Visitor
    7 years ago

    Anonymous,

     

    I believe that to one PowerBI report can only have one dataset. I have measure that do some calculation over this table. Moreover, this value will be visualize with data from other table in model in Azure Analysis Service. So, I need it to be based on my data model but the KPI_DEV can be triggered through Flow like a streaming dataset. Does current version support this functionality?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      PBIX123,

      I am afraid that it is not supported.

      Regards,
      Lydia