Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am facing an issue in opening a power BI report in June and July update. The moment I update the May version of Power BI to June or July Version, the Power BI throws an error as shown below.
Surprisingly, the moment I downgrade the Power BI to May version, the file is opening properly with no issue.
Please help me in this regard since I need to include some functionality from the June/July updates.
Solved! Go to Solution.
Hi,
So... real challenge then...
Could you copy your formula that is causing the issue? Also, I'd try erasing that column with the older version of power bi, open the new version and then try to create that same column... idk if it would work
Hi @rbiswas
What is the measure that is causing the error?
It would appear that the measure is not returning a single value as selected.
Hi @GilbertQ,
I have used a chicklet slicer whose Forced selection option is ON and Multiple selections option is OFF.
Surprisingly, it is working fine in May version ( I uninstall the June/July Version and then reinstall the May version)
The main problem is that the error is throwing while opening the report, so there is no way for me to look for the error in the report itself (While working in June/July Version)
Hi,
By any chance, does that meassure reffer to multiple tables?
I had a similar problem once, I was using the date to set relationships between tables, and with the upgrades, switched from spanish format to english, so... all messed up 😄
Hi @Salvador,
Yes, the measure which is reading the selection of my chicklet slicer is used in multiple tables. fortunately, I have the May version downloaded in my system, otherwise even I do not know what mess can happen.
Also, I need to transfer the ownership to somebody else. Now if this problem persists then even I do not know whats should i do about this
Hi,
Then, the issue could be related to the relationships between tables, could you check the active relationships? As it wont tell you at first wich one is causing the issue, you might need to edit each relationship, and check if it will allow you to click on "ok".
Hi
But the problem is the report is not opening at all since it only shows the error.
Do you want me to open the report in the May version and check the relationship?
Hi,
If you can open it in the may version, then "un-tick" the "active" boxes for all the relationships, then... on the new version, try to set them to active ^^
Hi
Not working, Even deactivating all the relationship, it still throwing the same error.
Hi,
So... real challenge then...
Could you copy your formula that is causing the issue? Also, I'd try erasing that column with the older version of power bi, open the new version and then try to create that same column... idk if it would work
Hi @Salvador
Thanks a lot for your help.
Finally, it works although I had to make a lot of changes in that.
Just to underline the procedure I did to solve the issue, (if anybody else faces the same challenges)
1. In the old version (May version in my case), Delete the measure/column which is throwing the error. Save and Close it.
2. After upgrading to the New version (July version in my case), I created a new table which contains the column for the chicklet slicer along with a measure to read the selection of chicklet slicer (For example in my case it is [Read Measure]).
(Surprisingly, there is no difference between the old and the new table, may be some sort of Bug appear during the update process)
3. Replace the old measure used in different calculation by this new measure.
Hi,
So... real challenge then...
Could you copy your formula that is causing the issue? Also, I'd try erasing that column with the older version of power bi, open the new version and then try to create that same column... idk if it would work
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |