Power BI Report Builder_ Failed to preview report
I am trying to build a paginated report on Power Bi report builder. I have a valid stored procedure on my SqlServer DB. To keep the consistency of the design ( formatting, colors, text aligning) I created a copy of the existing report and deleted the dataset which was in it. And added my own dataset. Deleted the tablix column content from the existing report copy and filled the columns with my datasets columns. But when I run the report, it shows: " The hidden expression for the textbox 'Textbox11' has ascope parameter that is not valid for an aggregare function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset". Did anybody come accross this issue in the past? How could you solve it?DM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)
So I have multiple reports that pull from 1 or 2 MySQL databases, Most pull from the same database in which I get this error. The "table" at the end of the error varies. And this error is not constint, some days out of the 6 reports I get 1 or 2 of the reports that get this error message, some days I dont get any, and about 10 mins before this post I got all 6 (same error message minus the table at the end). Now If I go to power bi > data sources > and manually click the refresh I never get any errors, this only occurs randomly during the auto refreshes. I made sure my On-Premises Data Gateway is up-to-date and refreshed/restarted it. The MySQL connections are good with encription not enabled and under Orginization not public. This has been happening off and on for about a month now. I would normaly think it would be something on my end, but if it was I wouldnt be able to refresh it without errors via the power bi site or on the desktop editor as well. So Im sure its a odd setting somewhere, anyone have any ideas?
Actualization Infinite
Hello! My dataset is showing an error when I try to update automatically, it keeps loading infinitely and at the end it shows an error message (information is needed in order to combine data; information about a data source is required... The exception was raised by the IDbCommand interface. Table QuestionsTransportePessoas) does anyone know how to solve this error?
