Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Unable to import table in Tabular editor

Hi,  We are facing issue with importing a new table in tabular editor .It is throwing an error message 'unable to read databases from the source'.This table is available in the DB(SSMS) The credent...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous Could you check if the Authentication mode used for refreshing data in Power BI are also configured for Tabular Editor,and try syncing the Tabular model and Update the connection string could you check for these 

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hello Anonymous 

Thank you   for your promp response.

Thank you for reaching out to the Microsoft Fabric community. We understand that you are experiencing issues while importing a new table in Tabular Editor.

The issue seems to arise from an authentication mismatch between Power BI, Tabular Editor, and SQL Server. Since the dataset in Power BI uses Service Principal authentication, while Tabular Editor was previously using SQL-based authentication, it is essential to ensure that both environments use the same authentication method. Also, verify that the Service Principal has the necessary read and connect permissions on the SQL database to ensure seamless access. Configuring these settings correctly should help resolve the issue.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally,a 'Kudos' would be appreciated if you found my response helpful.

Thank You!