Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have shown several measures on a multi-row card. This works when the source is an Excel-file. However, I get different results when the source is a SQL Server (which contains the same data as the Excel-file). Does anyone know what the problem might be and how I can solve it? Thanks in advance!
@MO wrote:
I have shown several measures on a multi-row card. This works when the source is an Excel-file. However, I get different results when the source is a SQL Server (which contains the same data as the Excel-file). Does anyone know what the problem might be and how I can solve it? Thanks in advance!
What are the different results, could you show some snapshots? I'm not able to reproduce this issue, will you upload one pbix file with excel data and another with data from SQL Server? You can upload pbix files in web storage like Onedrive and share me a link in a private message. Do mask sensitive data before uploading.
@Eric_Zhang Thank you, I have already solved the problem. It had something to do with historical data.
@MO wrote:
@Eric_Zhang Thank you, I have already solved the problem. It had something to do with historical data.
Do you mean that the visual works fine, the difference is caused from the data inconsisitence between Excel and SQL Server?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |