Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm having trouble debugging my powerbi dataflows, and would appreciate some guidance. When I try to refresh them I'm given a nondescript error that lists a Request ID, an Activity ID, then nothing else.
To resolve this I decided to go to the edit page of the dataflow to see a more descriptive error, but the only information I get is a yellow triangle warning sign at the bottom left. When I hover over it, it says "The query X contains errors."
I'm not sure how to get more information. I tried removing the majority of my M code in the advanced editor, but the error remains. I have an on-premise gateway that is ostensibly working. Not sure what to check from here.
Any help understanding what's going on or what to check next would be appreciated.
Solved! Go to Solution.
Sorry for the late reply, I figured out the issue.
Power BI recently, apparently had an update to how it connects to SQL CLR databases. 0-length passwords used to be allowed but now are not. I had to change my password from nothing to something in SSMS and then update my password in power bi connection settings. Everything worked fine after that.
I should note that there was no error with my nothing-password until I erased it and put nothing as my password again, which was not allowed and I was asked to input a password. That's why it took awhile to track down.
Hi @AnthonyMCUBI ,
Click on the warning message and you will see more tips.
If the problem is still not solved, please post your M code(You can copy the code in "Advanced editor".)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the response.
Below is the popup text box that appears after I clicked the error description mentioned in your response.
Since the popup doesn't give me extra information, I've also added the M code (in a picture, and then pasted):
This is very strange, I checked your code carefully and found no errors.
What is your data source? SQL Server?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for the late reply, I figured out the issue.
Power BI recently, apparently had an update to how it connects to SQL CLR databases. 0-length passwords used to be allowed but now are not. I had to change my password from nothing to something in SSMS and then update my password in power bi connection settings. Everything worked fine after that.
I should note that there was no error with my nothing-password until I erased it and put nothing as my password again, which was not allowed and I was asked to input a password. That's why it took awhile to track down.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.