Measure Formula Bar not showing on Direct Connect SSAS Tabular Model

[powerbi1980]

This was working fine last week, and this morning it is not working for me. Version below:

Version: 2.123.684.0 64-bit (November, 2023)

I was able to create and modify measures in Power BI Desktop that was connected to an SSAS Tabular model via direct connect rather than import. This week, it appears that I cannot modify the measure DAX because the formula bar does not appear. It works fine when I change from direct connect to import. What has happened over the weeked? Did an update kill this functionality?

Measures that I created last week in my live connect files still work, i just can't modify them. Makes me think this is a bug.

[Anonymous]

Is this still the issue in Feb. 2024? Whenever I click on one of my existing measures, the formular bar does not show up. This is a major issue.

[Thomsens]

Hi Cerwan, I still have the Power BI Desktop December 2023 version. If this is the case for the February 2024 verison and it worked for previous verisons, I would recommend uninstalling the current version and installing an older verison as a temporary work around. This is located in the "Previous Monthly Updates to Power BI Desktop and Power BI Services". Make sure to download the proper bit size (i.e. 32-bit or 64-bit) based on your systems requirements.

[v-tianyich-msft]

Hi all,

This issue will be fixed in the Dec. release Power BI Desktop.

Best regards,
Community Support Team_ Scott Chang

[lkerka]

Please fix this issue .  Also, how can I get the Oct version of Desktop - I only see the Nov release which is what I have and is causing the problem

[Thomsens]

Hi Ikerka,

Great question, I was running into the same issue [Note: The following directions are for Windows 11 and may require administrator privileges]. To resolve this, the link I provided below has Microsoft replying with the download to the October Power BI Desktop version. During the process of installing it, which will be the installation file in the downloads folder, you will get to the following pop-up window:

At this point, you will want to rename this file location to make it easier to locate the shortcut.

Then towards the end of the installation you will want to check both boxes for "Create a Windows Shortcut" and "Launch the Power BI Desktop". Now for the fun part, when you go to your windows start menu and look at all applications, scroll down to location "Power BI Desktop" you will notice that there are two. However, one will have "New" next to it, this is the October verison (In my example, I already renamed it but it serves as a reference point).

You will want to right-click, go to more, and open file location.

The file path is C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Power BI Desktop, which shows as below:

This is were renaming the shortcut will help identify the different verisons of Power BI Desktop. To rename the shortcut, right-click on the file and select "Rename".

Now you can copy the shortcut and paste to your windows desktop and tell the difference between the verisons.

For further verification, please open the "Power BI Desktop_Oct" verison, click the "Help" tab, and then the "About" tab. The pop-up window will display the following:

Please let me know if this helps and enjoy the day!

[Thomsens]

This is Microsoft's solution as of November 26, 2023, which is to down grade to the October 2023 version for the time being.

https://community.fabric.microsoft.com/t5/Desktop/New-Desktop-version-I-can-t-create-new-measures/td...

[v-tianyich-msft · Accepted solution]

Hi @powerbi1980 ,

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

Best regards.
Community Support Team_Scott Chang

[Anonymous]

Please resolve this issue soon as possible now its dec 2023 and users are facing issues.

[jtsys2]

Same here, please fix soon . 

[Ecervera]

I'm experiencing the same issue with analysis services connection live, I can't view formula bar. 

[Christianwmcld]

Same scenario on my side. Using connection with Analysis services. 

[pricehammond]

I'm also running into this. please help!