Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi there PowerBI community!
At the end of each month I need to report on month end numbers.
The one source is from SQL which contains underlying data, I simply do a count of the rows, the other is a xls file which is on Sharepoint that simply contains the overall number and the date (no underlying data)
I have set it up so the xls file appends to the SQL query in the Desktop. When I refresh and publish to the service the numbers are correct. Problem comes in when I refresh the model in service. The service returns a different number
Example Instead of 14269 I get 99883.
All three queries are setup as dataflows (XLS, SQL and a Date Table)
I was thinking this may be date related so I have tried changing the date type both Using localle... and Default
Also for the XLS file using a direct query in the model to Sharepoint rather than a BI dataflow but unfortunately also not giving me the correct result.
Any more suggestions of what to look for would be appreciated as I have been trying to resolve for the past three days.
Solved! Go to Solution.
Hi @NoelGrieve
I am sorry for the issue you are experiencing.
Please create a support ticket for assistance.
Best Regards,
Link
Hi @NoelGrieve,
You can drag the same fields into visual and check.
Maybe some filters affect the outcome.
Best Regards,
Link
same visual no filters, when I refresh and publish from desktop, I get the correct result. when I refresh via service the number changes to be incorrect.
Hi @NoelGrieve
I am sorry for the issue you are experiencing.
Please create a support ticket for assistance.
Best Regards,
Link
A couple of things don't sound right here. Power BI service cannot handle .xls files. Did you mean .xlsx ?
What's your reasoning for using dataflows?
yes correct, xlsx file. using dataflows or power query online as this means the query is decoupled from a specific dataset and can therefore be re-used.
User | Count |
---|---|
42 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
43 | |
24 | |
21 | |
20 |