Calculated measurements and columns

[Anonymous]

Good I'm doing a dashboard that gets the data from a SQL Server database. That database has an equal structure and name for all sites where it is deployed. Finish the dashboard and the goal was for that same dashboard to serve other databases (with the same name and structure). But when I told you to take the data from the other database, everything went right except the previously calculated columns and measures that were not passed. Is there any way they can pass without having to do them again?

[v-xicai · Accepted solution]

Hi @Anonymous ,

If we disable the option "Enable Load" for the query, when we apply the change, this query table data will not be loaded to data model. Any visuals attached to this query will not work after this change. Which is totally fine, because this query is not used (and won’t be) for any visualization. There will be a message "Disabling load will remove the table from the report, and any visuals that use its columns will be broken."

While when we refresh the dataset, there is also a query sent to data source. See: https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up .

Best Regards,

Amy 

Community Support Team _ Amy

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

[amitchandak]

@Anonymous , hope you changed the connection properly

https://www.youtube.com/watch?v=mqoV-CRegp8

https://blog.decisivedata.net/blog/change-a-power-bi-data-source-type

[Anonymous]

I think I've done it right. I have a created parameter that serves me to tell you the IP address of where the database I want is. From what I see, it's the same thing he does in the video. But the calculated columns and measurements are gone.

[Anonymous]

I tried doing the same procedure I did before but removing some tables to do the test. Passing fewer tables I have seen everything working correctly and I realized that what I was taking away the calculated columns and measures was that due to the large number of tables and rows that these have I caused a memory error when updating everything at once so that for this error not to appear I was removing the option to enable load. Removing this option from a table if there were calculated columns or measures in it disappear. Now if I can't disable that option to be loaded by groups instead of all together that I can do so that I don't skip the memory error in the POWER BI?