Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous , 

     

    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.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

 

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.

  • ValentinLenkSBS's avatar
    ValentinLenkSBS
    Frequent Visitor
    3 years ago

    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?