Forum Discussion

mj47's avatar
mj47
Frequent Visitor
2 years ago

Upload Error in Power BI Desktop May 2024(After using DAX query view)

Hello all, When I try to upload pbix file(desktop ver.2024 May ) with using the DAX query view, I have an issue like below after upgrade to Power BI Report Server 2024 May.     Once an err...
2024 May
DAX query view
mj47's avatar
mj47
Frequent Visitor
2 years ago

hi Anonymous 

Thank you for your answer.

But, I'm sure that both Power BI Desktop and the Power BI reporting server have been updated to the latest version because I'm a server manager.

I think there are some compatibility problems with the Dax Query view feature.

When I didn't use Dax Query View feature, there's no issues. 

Is there any server settings to use Dax Query View feature?

 

Thank you for helps.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
2 years ago

mj47 - my appologies, this error usually happens when people attempt to use the cloud version of desktop with the on-prem report server. But I can reproduce your issue on my local version of Report Server (May 2024). I can see that clicking on the DAX Query View triggers a version update in the pbix file so I think this is a bug. I've flagged this with the MS team, but it could also be worth you raising a support ticket. I'm not aware of any workarounds at the moment.

  • Boni8's avatar
    Boni8
    New Member
    2 years ago

    Seems that there is a workaround to fix the issue. Please be careful and do backups of your files. 

    1. Change the extention of .pbix file to .zip.

    2. Unzip the archvie.

    3. Delete DAX Queries folder and SecurityBindings file.

    4. Replace files Settings and Version with any respective files from any other .pbix file where DAX Query Preview wasn't used (even empty file works).

    5. Add all files and folders to archive .zip. (Be careful to do not add old .zip file) 

    6. Change the extension of new .zip file to .pbix