topic Re: Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered. in Dataflow

Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered.

foks — Tue, 02 Jan 2024 14:39:15 GMT

Hello,

I installed the gateway and configured SQL Server Data Source. It works when I'm using navigation pane and select table but when I want to use query instead e.g. select top (100) * from [schema].[table] - it doesn't work.

It is showing an error in power query: A non-serializable exception was encountered.

In Gateway log I have: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessPermissionException: The evaluation requires a permission that has not been provided. Data source kind: 'SQL'. Data source path: 'servername;dbname'. Permission kind: 'NativeQuery'.; ErrorShortName: MashupDataAccessPermissionException

In Power BI Desktop, when I try to use native query, it shows warning and I have to click accept. And then it works. I didn't found any similar window/options for DFG1/DFG2 in Fabric. (Classic DF shows the same error).

The authentication is SQL Server login authentication.

Many thanks for any help. Unfortunately I cannot use Data Pipelines instead of Data Flow because it doesn't support SQL Server on-prem yet.

Re: Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered.

Anonymous — Wed, 03 Jan 2024 11:18:07 GMT

Hi foks ,

Thanks for using Microsoft Fabric Community.

Apologies for the issue you have been facing.

This might require a deeper investigation from our engineering team and they can guide you better.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Re: Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered.

Anonymous — Thu, 04 Jan 2024 08:47:30 GMT

Hi foks ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. In case if you have created please provide the ticket number here as we can keep an eye on it.

Re: Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered.

Anonymous — Fri, 05 Jan 2024 07:01:08 GMT

Re: Dataflow with SQL Server On-Prem and Gateway: A non-serializable exception was encountered.

Element115 — Thu, 01 Feb 2024 02:05:13 GMT

Instead of inserting a SQL Query in M code, have you tried to simply get the data first into the Power Query editor (by just selecting the data source using the GUI) and then use the menu/toolbar functionality to filter the data according to what you want?