Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JeffH
Helper I
Helper I

Desktop Report will not open Says "the model does not have a named expression....

‎04-27-2020 03:19 PM

Annotation 2020-04-27 181230.jpg

 
 
Labels:
Message 1 of 4
322 Views
0
1 ACCEPTED SOLUTION
edhans
Super User
Super User
In response to JeffH

‎04-27-2020 05:08 PM

Download the PBIX file from the service and see if that works.

  1. Go to the dataset for the file
  2. Click on the ellipses
  3. Download PBIX

Hopefully that works. I always store my PBIX files in OneDrive (all my files actually) so there is always a backup via OneDrive's built in versioning. Or Sharepoint. Same versioning happens. Keeps 500 versions for you automatically.

 

2020-04-27 17_06_24-Power BI and 12 more pages - Work 2 - Microsoft​ Edge.png



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

Message 4 of 4
293 Views
3 REPLIES 3
edhans
Super User
Super User

‎04-27-2020 03:28 PM

Probably a corrupt file. Do you have a backup?

 

Did you modify the file using Tabular Editor or any other 3rd party tool? 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 2 of 4
319 Views
0
JeffH
Helper I
Helper I
In response to edhans

‎04-27-2020 04:47 PM

I have no backup, just built it a few days ago. I did not use any third party tool. It was working fine and then just stopped. Works and refreshed fine in Service. 

Message 3 of 4
297 Views
0
edhans
Super User
Super User
In response to JeffH

‎04-27-2020 05:08 PM

Download the PBIX file from the service and see if that works.

  1. Go to the dataset for the file
  2. Click on the ellipses
  3. Download PBIX

Hopefully that works. I always store my PBIX files in OneDrive (all my files actually) so there is always a backup via OneDrive's built in versioning. Or Sharepoint. Same versioning happens. Keeps 500 versions for you automatically.

 

2020-04-27 17_06_24-Power BI and 12 more pages - Work 2 - Microsoft​ Edge.png



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 4 of 4
294 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All