Power BI Desktop evaluating all data sources when creating new data connection

[AL123]

Hello, 

I have a report with several ODBC data connections.  When I add a new data source (also ODBC) Power BI "Evaluates" all exisiting data sources before loading my new data source.  A few months ago I was able to create a new data connection without this happening.

Is there a setting I need to change to only load and apply the new data connection upon creation?

[v-xulin-mstf]

Hi @AL123,

Is your issue solved?

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @AL123,

Sorry for delay reply.

Baesd on my test, you can change the privacy levels to solved the issue.

Change the setting as:

When Ignore the Privacy levels and potentially improve performance is selected, the data will be combined ignoring your Privacy Levels which could reveal sensitive or confidential data to an unauthorized user. The setting may improve performance and functionality.

Security Note: Selecting Ignore the Privacy levels and potentially improve performance may improve performance; however, Power BI Desktop cannot ensure the privacy of data merged into the Power BI Desktop file.

You can refer: https://docs.microsoft.com/en-us/power-bi/admin/desktop-privacy-levels

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[AL123]

I matched those settings and it did not resolve the issue.

[amitchandak]

@AL123 , try to change the first two setting and check