Forum Discussion
Export data doesnt match
Hello All,
Do we have a solution for the exported file in the dashboard? It's pulling an incorrect result. It's related to role level security, He should only get a data that is intended for him not everything. The dashboard shows right but the exported file doesn't. Please advise as it's a huge issue with all users.
Thanks
Same problem persist. I have table full of various values. When I press to export it to csv file, my number column gets mixed up. 1,2 ish values sometimes become "15.666.666.666.666.600". In report view this is 1.57. I do however have to agree that software is buggy and at emberassingly crucial area. Especially when there isn't any easy option to just export data in other ways which would provide me with quick fix. Strangely enough, sometimes Power Bi saves data in properly formated format. I do not need to use excel's text to columns function. Sometimes however it randomly decides not to format data for me and it distorts information. Even if it is portrayed properly in Excel's text to column menu in how it is going to be formated.
Edit: I had managed to painfully solve my own problem. The issue was in how excel separates numbers (dot or comma). If my settings in Excel are not exactly as they need to be, numbers get completely destroyed when I convert csv data into readible excel information. It is impossible to convert it back afterwards. However, if I have correct settings before using text to column function, information transfers correctly. However, I do think that more export options are needed. This is not yet a feature in Power Bi as far as I know:
This is why I believe that some users in some extreme cases encounter said issue of Power Bi not exporting its values correctly. Having more options than 1 to rely on while quick exporting your data is important. Power Bi does not have flexibility or power of most programs with their Save As functions and as far as I know, there isn't any other quick way to get your data out.