Forum Discussion
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 ...
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.