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.
I was able to resolve the issue by reconsolidating my web calls into a single query instead of a query and a function. A combination of not parsing the web results to a table and keeping them all in one call did the trick.
I thank you for the insight on the privacy level handling that DFGen2 enforces. The power query prompted me to disable the privacy levels when the issue first emerged and I had no idea that would not persist when uploaded to fabric, so that insight was invaluable. thank you again.