The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone, I need to raise the following topic, as I have not been able to find the solution to my problem.
I tell them to develop a financial model, which considers the budget for the year. The connections I have in my model are: Sap for the actual information and an excel for the budget information.
Now, this load in the power bi service, I do it through incremental load and when the system updates the signature, it adds up many times the information of the budget (information in excel).
I share what the power bi service throws at me.
The correct information and that is in excel is as follows
Specifically, what Power Bi web is calculating for me is adding 38 times the data found in the excel file.
The weird thing is that when I update my model in power BI on the desktop, I don't have this problem, it's just generated in the web service.
Show the piece of your Power Query code where you apply the RangeStart and RangeEnd filters.
RangeStart
RangeEnd
From the editor
I have the following query, the date range with incremental load is at the end of the query, by this I mean I have queries appended after the RangeStart and Range End condition.
Your parameters look good. Now show the query where you use them.
Exieten queries based on SQL connection and excel file
Both consultations were consolidated and annexed in a sheet called consolidated
Now the report in the web service throws me
January, it adds two months to the values, February gives it to me correctly and from March to December it doesn't give me values.
In summary, the information in ppto 24 is only read for the months of January and February (January adds the values twice and February correctly)
Filter from March to December
Your filter is wrong. Only RangeStart should be inclusive. RangeEnd must be exclusive.
each [RefDate] >= RangeStart and [RefDate] < RangeEnd
Change and review the filters, [RefDate] >= RangeStart and [RefDate] < RangeEnd
And now the result is that January is right
But from February onwards I don't get any information from PPTO 24
Could it be related to the fact that I don't have data as real 2024?
User | Count |
---|---|
82 | |
82 | |
35 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |