Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Data not correct for after connect with SQL analysis services

Hi , 

 

i have an excel file which is connected to SQL ...however the file runs very slowly everytime i need to add in a filter on my pivot table. 

Thus, i tried to connect the datasource with power bi to solve the problem. When i checked the data  after connecting with the same datasource using sql analysis services, the numbers is not correct . Some is a duplication of the correct amount, amount is totally off. May i know how can i solve this?

 

Thanks in adv

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , In power bi data tab(icon on the left vertical bar), check the number of rows(in the status bar)  by clicking on the table. and check is it matching

     

    Open power query and check error for any row.