Forum Discussion

Tom_pbi's avatar
Tom_pbi
Regular Visitor
4 years ago

Report Builder Data not working on Power BI Service

Hi all,

 

My situation is that I have built a report using Report Builder that pulls data from a Power BI dataset published in a workspace. This report works perfectly when I run it on the desktop version of Report Builder. However, when I publish it to a workspace (this is a premium workspace and I have a premium license), the report runs without error but any expressions that should have data in them are blank. I can't figure out why, but there is obviously some missing link in the connection to the dataset on Power BI Service.

 

Any help would be much appreciated!

 

Thanks,

Tom

Need Help

3 Replies

  • bradsy's avatar
    bradsy
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Can you post expression examples. Might help us figure out if the expression is the problem. You might consider contacting support if it works in report builder and not in the service. 

    • Tom_pbi's avatar
      Tom_pbi
      Regular Visitor
      4 years ago

      Sure thing.

       

      I am only using a few very basic expressions which I will list below;

       

      =First(Fields!StartTime.Value, "DataSet1")

      =First(Fields!EndTime.Value, "DataSet1")

      =First(Fields!Duration___hh_mm_ss.Value, "DataSet1")

       

      I am also using the "=today()" expression which works without issue.

       

      I feel that there must be a link to the dataset that is missing on Service but I'm not sure where that could be. 

       

      Thanks!

      • bradsy's avatar
        bradsy
        Icon for Microsoft Employee rankMicrosoft Employee
        4 years ago

        For a PBIDataset, the name is usually based off of the PBI Dataset name. Is DataSet1 the correct name for the dataset? And you are using the PBIDataset connection type and not one of the AS connection types?