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 ...
Need Help
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?