Forum Discussion
ExceptionMashupException.Error: Expression.Error: We cannot convert a value of type Table to Record
Hi zdice
Thank you for reaching out microsoft fabric community forum.
The "Mashup Exception Expression Error" in Power BI occurs when Power Query is unable to process an expression correctly. Specifically, the error message "We cannot convert a value of type Table to type Record" means that Power Query is expecting a Record, but it received a Table instead.- Dataflows Gen 2 enforces stricter privacy levels and credential handling than Power Query in Power BI Desktop.Ensure your data source is set to Organizational or Public in Power BI Service → Settings → Data Source Credentials.
- Since you’re logging in and obtaining a token, check if the API session expires before the second query (RaasExcute).Log the token response (loginData) in a separate table to verify if the service returns an invalid session.
If the issue persists, we recommend raising a support ticket for further assistance. To create a support ticket for Fabric and Power BI, please refer to the steps outlined in the following guide:
How to create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Thank you.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.
Hi zdice
Thank you for reaching out microsoft fabric community forum.
The "Mashup Exception Expression Error" in Power BI occurs when Power Query is unable to process an expression correctly. Specifically, the error message "We cannot convert a value of type Table to type Record" means that Power Query is expecting a Record, but it received a Table instead.
- Dataflows Gen 2 enforces stricter privacy levels and credential handling than Power Query in Power BI Desktop.Ensure your data source is set to Organizational or Public in Power BI Service → Settings → Data Source Credentials.
- Since you’re logging in and obtaining a token, check if the API session expires before the second query (RaasExcute).Log the token response (loginData) in a separate table to verify if the service returns an invalid session.
If the issue persists, we recommend raising a support ticket for further assistance. To create a support ticket for Fabric and Power BI, please refer to the steps outlined in the following guide:
How to create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Thank you.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.
I was definitely using disabled privacy settings in the editor and organizational privacy settings on the connections. I will try to use public privacy settings on the connections and keep the privacy setting enforcement in my editor UI. When I have a working solution, I will share here. Also, the token has a 15minute expiration from the vendor's API documentation, so I shouldn't have an issue there with the token timing out.