Forum Discussion

Rishabh_Bagga's avatar
Rishabh_Bagga
Frequent Visitor
3 years ago

Something went wrong There was an error when processing the data in the dataset.

Noob to powerbi here. I just started using Powerbi recently for my company and right now I am having an issue with one of my reports. I have created a Powerbi desktop-based report from Dataverse and ...
Refresh and Column Issue
Rishabh_Bagga's avatar
Rishabh_Bagga
Frequent Visitor
3 years ago

Hi Anonymous 

I understand the reason why it's not working now but my main concern is if my date column would have come in hierarchy format, there was no need for me to create a calculated column. I would like to have that in the hierarchy and I will delete the calculated column. 

Now what's happening is, the data is in the dataverse and when I published the report, the reports are connected directly with dataverse without the dataset and they are refreshing properly at the same time whenever any change is made in dataverse.  This is really confusing because other reports that I have created are having the dataset and report in the workspace but this particular report is showing no dataset.  This is how other users are viewing the workspace

And this is how I am viewing the report.

 

Thanks

Rishabh bagga

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Rishabh_Bagga ,

    1. For auto date/time generated hierarchy need you to check a option in Power BI Desktop Options.

    2. If other users are the Viewer role for the workspace, they could not see the dataset. 

     

    For more details, you can read related document: Auto date/time in Power BI Desktop - Power BI | Microsoft Learn , Roles in workspaces in Power BI - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Rishabh_Bagga's avatar
      Rishabh_Bagga
      Frequent Visitor
      3 years ago

      Hi Anonymous , the auto date/time is already turned on and by default it was ON, but even after that, I was unable to see the Hierarchy of the Date/Time.

      Even if it is On, the main question is why it is not coming and if I even uploaded the reports to the PowerBi online, Why the reports are directly connected with dataverse and not with my dataset? This is surprising because I haven't created a THIN report but the system is creating it and it is directly connected to Dataverse without a dataset. I mean it's not Supposed to be connected with the dataverse directly but should be connected through the Dataset right?