Skip to main content
cancel
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
tkim
Regular Visitor

This model doesn't have a table named

I made changes to a view named Product in the SQL Server and when I tried to refresh the view in Power BI, it gave me an error saying "This model doesn't have a table named Product." The changes that I made were to just add a couple columns in. The view exists within my data model and when I preview the data in PowerQuery it shows up correctly. It was working before, but after the changes it stopped working and gave me this error message. What may be creating this issue?

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

Hi @tkim , 

 

You may try to rename the table in The Fields pane.

 

Or you may clear permissions under "Data Source settings", and establish the connection to SQL Server again.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Pierro_Schoeman
New Member

Having the same issue...

Anonymous
Not applicable

This solution did not work. The names are identical between the Power Query Editor and the actual PowerBI Fields section. Any other ideas please?

Error:

"The model doesn't have a table named <name of table>"

v-xicai
Community Support
Community Support

Hi  @tkim ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

v-xicai
Community Support
Community Support

Hi @tkim , 

 

You may try to rename the table in The Fields pane.

 

Or you may clear permissions under "Data Source settings", and establish the connection to SQL Server again.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I can't rename the table without first discarding all changes to the queries. Given that the error in my case occurred after a significant overhaul to the structure of the queries, that would mean redoing a lot of work. Resetting the connection permissions did not solve the issue.

 

Is there a method that wastes less time?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.