Forum Discussion

Bobby74's avatar
Bobby74
Regular Visitor
6 years ago

Cnnot Touch the formula bar

Hi People,

 

As soon as I try to edit a phrase or write a phrase or touch the formula bar what so ever, I get this error;

 

Would anyone be able to assisst please?

 

Thank you.

Bobby

Need Help

3 Replies

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hey Bobby74,

     

    If this error just happens on Power BI Desktop,

    First check if your server and database name is correct. Also check if your server has access to that database.
    If your data source is SQL Server database, use SSMS to connect to the same server and database, check if the connection works.

     

    Run Power BI Desktop as Administrator and turn off any virus anti app.

     

    If it happens on Power BI Service, please refer to

    https://community.powerbi.com/t5/Service/Report-couldn-t-access-data-source-in-Direct-Query-mode/td-...

     

    Please don't forget to give a 👍 and accept the post as solution. (If it helped 😉 )
    Have a nice day!

    BR,
    Josef
    Graz - Austria

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Bobby74 ,

     

    Seems like you are not able to connect database. Please go to data transformation/edit sources -> Edit connection/Sources and check connection details.

    It may be VPN or IP whitelist issue

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, Bobby74 

     

    I wonder which database and version you are using. Please make sure the data source with DirectQuery is supported in Power BI Desktop. You may refer the following link about the similar issue. Hope it helps.

    Unexpected Error: Couldn't load the model schema 

     

    Best Regards

    Allan

     

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