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?
Dax Forumula using power bi
i wanna make some calculation like this : if i filter like this images count calculation like this if i filter this one count calculation like this, if i filter the dept and type total utilization will be interactive, and i wanna make it real time if it possible Flat file relation : real time table i have : if filtered current date : active time, down time and not used keep mooving, cause this is real time data and i wanna ask relation regarding table fuel utillization and reg Data i Wanna Make some total utillization like that so far, i already make it using power bi this is flat file (not real time) the yellow mark, already correct but the red one still wrong, i wanna convert it to percentage SELECT vm.internal_id, vm.seq, vm.start_date_vhl_down AS start_date, vm.finish_date_vhl_down AS finish_date, vm.type AS trx, '' AS shift, vm.start_time_vhl_down AS start_time, vm.finish_time_vhl_down AS finish_time, '' AS duration, CONCAT(COALESCE(vm.start_vhl_down_note, ''), ';', COALESCE(vm.finish_vhl_down_note, '')) AS note, vm.status AS vehicle_status, vm.dept_id, vmd.value, vmd.detail, vr.vehicle_id, vr.type, vr.sub_type, vr.owned, vr.rent, vr.id_type, vt.id_type AS id_type_2 FROM vms_vhl_maintenance AS vm JOIN vms_vhl_mst_dept AS vmd ON vmd.id = vm.dept_id JOIN vms_vhl_reg AS vr ON vr.internal_id = vm.internal_id JOIN vms_vhl_mst_type AS vt ON vt.id = vr.id_type WHERE 1 = 1 --AND vm.internal_id = 'DTOF000004' --AND vm.start_date_vhl_down >= '2024-02-01' --AND (vm.finish_date_vhl_down IS NULL OR vm.finish_date_vhl_down <= '2024-02-29') AND vm.status = 'C'; SELECT vo.internal_id, vo.operational_date AS start_date, vo.operational_date AS finish_date, 'OPERATIONAL' AS trx, '' AS shift, vo.time_start AS start_time, vo.time_finish AS finish_time, '' AS duration, vo.note, vo.status AS vehicle_status, vo.dept_id, vr.vehicle_id, vr.id_type, vr.type, vr.sub_type, vr.owned, vr.rent, vmd.value, vmd.detail, vt.id_type AS id_type_2 FROM vms_vhl_operational AS vo JOIN vms_vhl_mst_dept AS vmd ON vmd.id = vo.dept_id JOIN vms_vhl_reg AS vr ON vr.internal_id = vo.internal_id JOIN vms_vhl_mst_type AS vt ON vt.id = vr.id_type WHERE 1 = 1 --AND vo.internal_id = 'DTOF000004' --AND vo.operational_date BETWEEN '2024-02-01' AND '2024-02-29' AND vo.status = 'C'; --/STEP 2/ (Crossing date ) SELECT vm.internal_id, vm.seq, vm.start_date_vhl_down AS start_date, vm.finish_date_vhl_down AS finish_date, vm.type AS trx, '' AS shift, vm.start_time_vhl_down AS start_time, vm.finish_time_vhl_down AS finish_time, '' AS duration, CONCAT(COALESCE(vm.start_vhl_down_note, ''), ';', COALESCE(vm.finish_vhl_down_note, '')) AS note, vm.status AS vehicle_status, vm.dept_id, vmd.value, vmd.detail, vr.vehicle_id, vr.type, vr.sub_type, vr.owned, vr.rent, vr.id_type, vt.id_type AS id_type_2 FROM vms_vhl_maintenance AS vm JOIN vms_vhl_mst_dept AS vmd ON vmd.id = vm.dept_id JOIN vms_vhl_reg AS vr ON vr.internal_id = vm.internal_id JOIN vms_vhl_mst_type AS vt ON vt.id = vr.id_type WHERE 1 = 1 AND MONTH(vm.start_date_vhl_down) <> MONTH(vm.finish_date_vhl_down) --AND vm.internal_id = 'DTOF000004' --AND ( vm.start_date_vhl_down BETWEEN '2024-02-01' AND '2024-02-29' ) AND vm.status = 'C'; SELECT vm.internal_id, vm.seq, vm.start_date_vhl_down AS start_date, vm.finish_date_vhl_down AS finish_date, vm.type AS trx, '' AS shift, vm.start_time_vhl_down AS start_time, vm.finish_time_vhl_down AS finish_time, '' AS duration, CONCAT(COALESCE(vm.start_vhl_down_note, ''), ';', COALESCE(vm.finish_vhl_down_note, '')) AS note, vm.status AS vehicle_status, vm.dept_id, vmd.value, vmd.detail, vr.vehicle_id, vr.type, vr.sub_type, vr.owned, vr.rent, vr.id_type, vt.id_type AS id_type_2 FROM vms_vhl_maintenance AS vm JOIN vms_vhl_mst_dept AS vmd ON vmd.id = vm.dept_id JOIN vms_vhl_reg AS vr ON vr.internal_id = vm.internal_id JOIN vms_vhl_mst_type AS vt ON vt.id = vr.id_type WHERE 1 = 1 AND MONTH(vm.start_date_vhl_down) <> MONTH(vm.finish_date_vhl_down) --AND vm.internal_id = 'DTOF000004' --AND ( vm.finish_date_vhl_down BETWEEN '2024-02-01' AND '2024-02-29' ) AND vm.status = 'C'; SELECT vm.internal_id, vm.seq, vm.start_date_vhl_down AS start_date, vm.finish_date_vhl_down AS finish_date, vm.type AS trx, '' AS shift, vm.start_time_vhl_down AS start_time, vm.finish_time_vhl_down AS finish_time, '' AS duration, CONCAT(COALESCE(vm.start_vhl_down_note, ''), ';', COALESCE(vm.finish_vhl_down_note, '')) AS note, vm.status AS vehicle_status, vm.dept_id, vmd.value, vmd.detail, vr.vehicle_id, vr.type, vr.sub_type, vr.owned, vr.rent, vr.id_type, vt.id_type AS id_type_2 FROM vms_vhl_maintenance AS vm JOIN vms_vhl_mst_dept AS vmd ON vmd.id = vm.dept_id JOIN vms_vhl_reg AS vr ON vr.internal_id = vm.internal_id JOIN vms_vhl_mst_type AS vt ON vt.id = vr.id_type WHERE 1 = 1 AND MONTH(vm.start_date_vhl_down) <> MONTH(vm.finish_date_vhl_down) --AND vm.internal_id = 'DTOF000004' --AND ( vm.start_date_vhl_down < '2024-02-01' AND vm.finish_date_vhl_down > '2024-02-20' ) AND vm.status = 'C'; can some one help me ?? rajendraongole1 lbendlin Ritaf1983 Kedar_Pande SamWiseOwl parry2kDM_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?errors shared reports PowerBI
Goodafternoon, Hopefully somebody can help me with a error. When a share a report to my colleagues they get this errors: The error is in English: "This visual contains limited data" I don't understand what the cause is of this error. Is there somebody how knows the solution?
