msimanek's avatar
msimanek
Regular Visitor
3 years ago
Status:
Needs Info

Measure using USERELATIONSHIP works in Power BI Desktop but not in Power BI Service

Hi Community,   Few days ago, one particular issue appeared in our report's measure on Power BI Service.   Measure is using inactive M:N relationship which is activated in measure using USERELATI...
Data Modeling
Report Server
Reports
msimanek's avatar
msimanek
Regular Visitor
3 years ago

Hi Anonymous,

 

  • Datasets for affected reports (with USERELATIONSHIP) are refreshed once daily from Monday to Friday - changing/updating data if there were changes in underlying source that day.
  • Initial data source is combination of Access DB and Web contents using our company API - "Access.Database(Web.Contents(API))"
  • Currently, in Power BI Desktop, USERELATIONSHIP  still works.
  • It doesn't work even if I rename and republish the report (also with scheduled refresh disabled)

Thanks andreasnord  for confirming.

 

Completed Ideas