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

[Rishabh_Bagga]

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 in that Dataverse, I have a column that is Delivery Date column that is a Date based Column and the data that goes to that column using Date and time. When I created the report, automatically it should give me the column as Hierarchy of Date. Still, it didn't give it like that and I had to create a calculated column for that and I had to manually create a relationship with the dataset table and Somehow I was able to create that but now when I published to Powerbi online, it's not refreshing the dataset in the system.

I am encountering this issue

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh over a dataset with a calculated table or a calculated column which references a Direct Query data source is not supported."}}],"exceptionCulprit":1}}} Cluster URI: WABI-CANADA-CENTRAL-B-PRIMARY-redirect.analysis.windows.net Activity ID: 8025db66-87b7-46f7-8adc-318d2566ff81 Request ID: 7e5ae977-d30e-4464-9c49-e9960c06ba2c Time: 2023-06-12 18:03:12Z.

Please Help.

Thanks

[Rishabh_Bagga]

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]

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]

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?

[Anonymous]

HI @Rishabh_Bagga ,

This is because DirectQuery mode have limitations: "Calculated tables and calculated columns that reference a DirectQuery table from a data source with single sign-on (SSO) authentication aren't supported in the Power BI service."

Please try to use Import mode.

For more DirectQuery limitations, you can read related document: Use DirectQuery in Power BI Desktop - 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.