I use a series of stored procedures to build tables in a dataflow that are used to feed several Power BI reports. For the past several days, I have been trying to add a single column to one of these queries, but when I do, I get this error:
Validating queries
An error occurred while validating your queries (Session ID: be7828b3-3af5-45a1-1c8652709587).
I can't find a way to troubleshoot this message. If I go back to the stored procedure and remove the column I tried to add (returning it to it's initial state), I get the same validation error. I have to click Cancel. I have been using many of these stored procedures for years. It's possible the error is on my end, such as a query returning multiple rows for the same key, but I have no way to debug. Can you assist? The above Session ID is correct.
Thank you,
chris
on:
Bi Crashes on launch with (AS Process PID=XXXXXX H...
on:
Fix the Date function in DAX
on:
May 25 update for Snowflake Connector v2 has broke...
on:
Unable to open existing PBIP files
mattlee
on:
Hover on button is not working with latest update.
Hi @cschnaars
Is your data source a SQL database on-premises? If your data source is database like SQL Server, you can use tool like Profiler to capture the queries sent to your data source to troubleshoot with it.
In addition, have your ever configured on-premises data gateway for your dataflow? If yes, you may consider enable Additional log option in your gateway app, then you should see some queries from Power BI Service in gateway logs.
In addition, please try to reconnect to this data source from Power BI to see whether queries will be validated successfully after you add column in your data source.
Best Regards,
Community Support Team _ Caiyun