Share via

How to fix "Pending queries" in Power BI?

Paula Olim Mendonça 0 Reputation points
2023-09-05T16:20:08.1+00:00

Hi,
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".

Help!
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.
13,817 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 111.4K Reputation points MVP
    2023-09-05T21:06:09.59+00:00

    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 https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums”

    0 comments
  2. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-09-06T05:42:46.24+00:00

    Hi @Paula Olim Mendonça

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

    https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi

    Best regards,

    Percy Tang

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.