How to fix "Pending queries" in Power BI?

Paula Olim Mendonça 0 Reputation points

Currently I'm doing the PL-300 learning path and in "Use DAX time intelligence functions in Power BI Desktop models" training, I can't do anything because it says that I've pending queries.

So if I try to change a column name or description, won't allow it and keep showing this message if I do "Apply changes".

issue PBI

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,918 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 87,271 Reputation points

    You need to do one of:

    1. Install the certificate for SQL Server as in your Trusted Certificates store.
    2. Select the connection option "Trust Server Certificate".

    The latter is less secure, but if this in your home environment, there is not really an issue with it. (If you would be working in a bank or a hospital with some really sensitive data, it would not.)

    Exactly how you set this option in Power BI desktop, I don't know. For help with PowerBI a good place is

    0 comments No comments

  2. PercyTang-MSFT 9,056 Reputation points Microsoft Vendor

    Hi @Paula Olim Mendonça

    Power BI has a separate community. You can go there for help.

    Best regards,

    Percy Tang